help with error message please!

[MarkRCC]

Hi.

Out of the blue I'm getting an error message when trying to enter data into a subform. The main form is used to select a employee from a table and the subform is used to gather data for the employee selected. All was working well and now I'm getting the following error message when attempting to enter data into the subform.

"The current field must match the join key "CmpnyID" in the table that serves as the "one" side of a "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."

Can anyone explain what this means exactly?

Many TIAs

Mark

 

[AndreAraujo]

Hi, the problem is in the fields that you are using in the relation.
When you insert data in the subform, the Field "CmpnyID" must exist in both tables, you are inserting a record in the subform that doesn´t exist in the mainform

Andre