I am setting up an order placing database. I want to be able to view and add orders on a subform by customer id's chosen in a mainform combo box. I have set this up many ways and continually I get an error message when I close the form after viewing different customers orders:
The changes you requested were not successful because they would create duplicate values in the index, primary key, or relationship.
I am new to Access and having trouble narrowing down the conflict. If anyone could help me out, it would be greatly appreciated. Thank You

Customers have a 1-to-many relationship with orders and orders have a 1-to-many relationship with items being ordered. Therefore I would expect you to have a subform to display/add items on the orders subform.

Make sure that the master/child links are properly set. Take a look at the northwinds.mdb and the orders.mdb. They both have samples of order entry forms.