Hi,

I have designed a database where I have a product table linked to an order details table through a one to many relationship.

I have made a user form linked to the order details table, which also pulls up information from the product table.

I have 5 drop down boxes on the user form which allows users to select products from the product table.

The structure of my product table is like this:


* Product ID
Product Name
Cost

The structure of my order details table is like this:
*Order details ID
Product ID

When I save the record, only the choice of the 1st drop down box is visible in the products table due to the relationship. Is there any way that I could get the other 4 drop down box choices to appear in the products table when the + sign is clicked on the products table?

Thanks in advance.