I have 3 tables:
With the following relationships;
Inventory links to Manufacturer via Manufacturer Name and Model Number.
Inventory links to Puchased via Order number and Model Number
When I try to add a new record via a form it get the following error:
"Then current field must match the join key'?' in the table that serves as the 'one' side of the one-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table.
I assume it gives this error because I can't update the Model number and Order number at the same time. Any thoughts?