What does this mean?- in English

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The current field must match the join key '?' in the table that serves as the
'one' side of one-to-many relationship....
 
In what context did you receive this message?

Here's a wild guess:
- This error occurs in a subform.
- The subform is bound to a query.
- The query contains 2 (or more) tables.
- You are trying to add a record to the related table.
- There are fields in the lookup table that have a Default Value.

If that is accurate, the problem is triggered when Access uses the Default
Value in the table on the one-side of the relationship and tries to add a
record there. Removing the Default Value from the fields in that table
avoids the problem.

Let us know if that is the context of your error.
 
That's amazing. That's exactly the context - but I hadn't thought about the
default value.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I prevent join key errors in Access? 1
Attachment in Form 1
Entering data with many to many relationship 1
Works in the query, but not the form!! 3
Problem with errror 3341 6
relationships2 14
error 3341 message when trying to create new record 1
Current field must match the join key?????? 1

Back
Top