How can I prevent join key errors in Access?

  • Thread starter Thread starter Quiche Lo
  • Start date Start date
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?
 
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?
 
Back
Top