Hi,
I have a form that allows a user to select a company from a list in a combo box and then add an order number for when that company places an order. I have my tables set up as 1 to many so that there is one Customer to many Orders (See below):
I want the database to allow the user to select a company and add a new order number for that company. because of how my tables are set up, I would need to tell the database to add a new Order ID number in the order table to do this. Right now, when I select a company and create a new order number, I get this error because it is trying to look for an existing ID number for that customer:
How can I tell the database to create a new Order ID number for that customer?