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
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
