Drop downs in a form

[johnmr]

I am building a customer order database for a client and have this problem: I would like to be able to display a form that shows all a customer's order information ( pretty standard stuff, first name, last name, address, phone, etc.) but then would also like to display what they ordered as a drop down. Many of the customers are repeat customers, and so they will have multiple order records in the datatbase, but I would like to somehow display them in the customer profile form all in one form.

Any help on how to go about this appreicated.

thanks in advance

johnmr

 

[RuralGuy]

Look into putting a SubForm on your customer profile form that displays the customer order records in a continuous format.

 

[etsoft]

populate this at a certain moment :

me.dropdown.rowsourse = "your query transformed to sql code "