The current field must match the join key?

Posted on 2010-01-12
Medium Priority
Last Modified: 2013-11-28
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?
Question by:JAMES125
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 77

Expert Comment

ID: 26294899
"Inventory links to Puchased via Order number and Model Number"

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

Author Comment

ID: 26295022
Not my requirement, I just follow orders!  So is there anything that can be done?
LVL 77

Accepted Solution

peter57r earned 2000 total points
ID: 26295203
Only by changing the relationship so that you do not require the parent to exist first (so no RI enforced)

You are trying to enter a record in a child table which requires the existence of a matching parent record, but where there is not and cannot be a matching parent (otherwise the child record would already exist - and so you have a basic paradox).

However even changing the RI settings will not result in the OrderNumber being added  to the parent record because Access doesn't work that way round.  

(Bear in mind that all we have to go on here is what you have posted.)


Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question