<div>
&quot;Inventory links to Puchased via Order number and Model Number&quot;<br />
<br />
Really? Why would you want to store order numbers in an inventory record? <br />

</div>


"Inventory links to Puchased via Order number and Model Number"

Really? Why would you want to store order numbers in an inventory record?


<div>
Not my requirement, I just follow orders! &nbsp;So is there anything that can be done?
</div>


Not my requirement, I just follow orders!  So is there anything that can be done?

<div>
<div class="content wysiwyg-content">
I have 3 tables:<br />
Inventory<br />
Manufacturer<br />
Purchased<br />
<br />
With the following relationships;<br />
Inventory links to Manufacturer via Manufacturer Name and Model Number.<br />
Inventory links to Puchased via Order number and Model Number<br />
<br />
When I try to add a new record via a form it get the following error:<br />
<br />
&nbsp;&quot;Then current field must match the join key'?' in the table that serves as the 'one' side of the one-to-many relationship. &nbsp;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.<br />
<br />
I assume it gives this error because I can't update the Model number and Order number at the same time. &nbsp;Any thoughts?
</div>
</div>


I have 3 tables:
Inventory
Manufacturer
Purchased

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?

The current field must match the join key?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.