Error: The current filed must match the join key in the table . . .

[User2007]

Hello Everyone.

I have a form which consists of multiple tables.
I have outer join relationship between the tables.

The foreign keys are on the form.
Every time I try to enter a value in the foreign key, I get this error message:
"The current field must match the
join key "?" in the table that serves as the "one" side of one to many
relationship."

But the foreign key that I am trying to enter is present as the primary key in the one side table.

Can anyone tell what is causing the error?

I am attaching my form and query images below.

Thanks.

 

[User2007]

Found out the cause of the problem, but not the solution.
I had attachments fields in my one side table.
After I removed the attachment fields from my form (not the tables), I stopped getting the error "The current field must match the join key in the table . . . "

To get more information on this problem, Google "A new empty row is added to the One table when you add a row to the many table .... ". It will be on Microsoft Support website.
I can't post a link because I have less than 10 posts.

 

[Richard1980]

Hello, I have (unfortunately) the same problem as you. Reading the MS KB article I learned that this problem comes up when using attachment field type, because it is a "complex field" introduced with MS Access 2007, along with a One-To-Many relationship.
Don't know if this problem hase been fixed with MS Access 2010.
I have a table with attachment field type which stores some .png files and need to share those files in other tables. I tried with a One-To-Many relationship on a specified field but no chanche to get rid of this problem.

 

[User2007]

Richard,

u have to follow the solution that Microsoft is suggesting: create a subform.
since u will need to use those attachments again, create a table where u want those attachments to be stored. u will need a primary key to identify those attachments.

in other tables u can use that key to indicate the attachments.

then u can use queries to view attachments in the other table.

 

[User2007]

Richard,

u have to follow the solution that Microsoft is suggesting: create a subform.

since u will need to use those attachments again, create a table where u want those attachments to be stored. u will need a primary key to identify those attachments.

in other tables u can use that key (the foreign key) to indicate the attachment.
then u can use queries to view attachments in the other table.

in the main form and the subform, u will need to use the primary key and the foreign key to make the relationship between the attachments. i can't clarify more on this b/c i don't know what exactly is it that u r trying to do.

 

[Shinta]

Greetings:

In my case, the problem was in the synchronization between my Form and its related Table (it was not ready by just creating a new record). It got solved by including a Me.Refresh before I tried anything else with the Form.

I hope this might help someone else in the same issue.

Regards,