adding records

[jwallace203]

I have a customer database with orders taken. On my orders page I would like to be able to add multiple products to the same order. How can I set it up so that when I choose a product from the drop down menu a second drop down menu for products appears underneath so I can choose another product to add?

[pbaldy]

What's your table structure? Typically you'd have two tables, one for the basic order data (customer, date, etc) and another for the details (a record for each product, including product, quantity, price), related by an order number field. On your form, you'd use a form/subform, with the subform in continuous or datasheet view. In that setup, as soon as you add a product on the first line of the subform a second line would be available to populate with a second product.

[jwallace203]

Yes, I have two tables and one of those is order details. I changed the view to continuous and now another record pops up the only problem is that it gives me a new order number. I want one order with ability to add multiple products. How do I do that. Sorry if this is basic; I'm pretty new to access and have been teaching it to myself. thank you

[pbaldy]

The master/child link properties of the subform control should be the order number. That will give each item in the subform the order number from the main record. The wizard should ask about that.