Creating a template for a standing order from a client

M

Michael

I have an orders database, I need to make a standard order for a certain
amount of clients. I want to put a dropdown list on the regular form for
orders that when the user chooses a client, the order list in the subform is
completed except for the amount of pallets.
I don't understand how to pull the info from a standing order table into
this form.
thank you for your help
Michael
 
J

jl5000

1.Create a table that contains the defaults per client, with all the lines to
be feed in the subform.
2.Add a valid_From and a Valid_To dates if you want those defaults to change
in ther future.
3.Every time you select your client in a new order run a query that appends
the defaults related to that client into your order lines/subform, this query
will select the records for the specified client and where the valid_from and
valid_to dates meet today's date.
 
M

Michael

Thank you,
I really don't need to change the order in the future.. so I will not need
to add the valid fields.
I would imagine that I can have a dropdown list that pulls the clients who
have standing orders from the new table, but how do I make an append or
update query that will place the standing order in the current order that is
on the screen? What I mean is how do I tell the query to place the standing
order information into this form?
thank you
Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top