B
Bob
I have a subform on a form linked by the main form's primary key with the
subform based on a table that represents the many-side of the relationship.
All was working fine until all of a sudden I now get the following error:
"The current field must match the join key '?' in the table that serves as
the 'one' side of one-to-many relationship. Enter a record in the one side
table with the desired key value, and then make the entry with the desired
join key in the 'many-only' table." A record is created on the main form
(creating a new record in the 'one' table) before making an entry on the
sub-form and was working fine. Can anyone shed some light on why this error
has just surfaced? Thank you.
subform based on a table that represents the many-side of the relationship.
All was working fine until all of a sudden I now get the following error:
"The current field must match the join key '?' in the table that serves as
the 'one' side of one-to-many relationship. Enter a record in the one side
table with the desired key value, and then make the entry with the desired
join key in the 'many-only' table." A record is created on the main form
(creating a new record in the 'one' table) before making an entry on the
sub-form and was working fine. Can anyone shed some light on why this error
has just surfaced? Thank you.