How can I prevent join key errors in Access?

**Quiche Lo** · October 5th, 2009, 01:39 AM posted to microsoft.public.access.forms

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?

**John W. Vinson** · October 5th, 2009, 02:41 AM posted to microsoft.public.access.forms

On Sun, 4 Oct 2009 17:39:01 -0700, Quiche Lo Quiche
wrote:

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?

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?
--

John W. Vinson [MVP]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode