ComboBox Values

[gkl]

Dear All,

I have an Order-Product scenario in which I want to display order details and in a sub-form the product details of the items in the order. That works fine and it is quite easy to set-up in Access 2013!

Now I want to change the display of the product name's attribute so that it will be a combo-box rather than a textbox. I can get the combo-box to show but I would like it to default to the item that is the product name; at the moment if the Product table has product1 and product2 as product names and I am looking at an order that contains product2, product2 will not automatically be the value of the combo-box but it will be empty, product1 and product2 (i.e. all the values from the Product table).

Is there a way I can get the value to be the name of the particular product in the particular order?

Regards,
George

 

[jdraw]

You may want an additional table -depending on your needs - to identify the many product names associated with 1 Product. This would be a 1 to Many relationship.

You may want to investigate Normalization.

Good luck with your project.