How can I prevent join key errors in Access?

Q

Quiche Lo

I have created an Access database. When I attempt to test a form in the
database, I receive the following message: "The current field must match the
join key "?" in the table that serves as the "one" side of one to many
relationship." All tables in question have a one to many relationship. How
do I correct this error?
 
J

John W. Vinson

On Sun, 4 Oct 2009 17:39:01 -0700, Quiche Lo <Quiche
I have created an Access database. When I attempt to test a form in the
database, I receive the following message: "The current field must match the
join key "?" in the table that serves as the "one" side of one to many
relationship." All tables in question have a one to many relationship. How
do I correct this error?
Click to expand...

By correcting the error in the form.

What are the Recordsources of the form and the subform? What are the Master
and Child Link Fields?
 

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

Attachment in Form 1
Works in the query, but not the form!! 3
Entering data with many to many relationship 1
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Synchronized combo boxes... 1
subform one to many error 1
One to Many data Error 2
Combo List Filters 1

Top