Join key of table not in recordset

[uaguy3005]

I have a database I'm trying to create to track changes in our manufacturing process. Changes are recorded, and the operators can enter what was done to validate the part and who approved the change.



When I try to enter a record on the main form frm4MChange, I get an error that the "Join key of table tbl4MChange is not in the record set". Any suggestions on how to address this?

Database attached

[pbaldy]

Offhand, IssueID from tbl4MChange needs to be added to the record set (fields selected). That should resolve that error anyway.

[uaguy3005]

That corrected the first error, but now I'm getting "Microsoft Database Engine cannot find a record in the table "tblPartvalidation" with key matching fields PartvalidationId. Any suggestions on this one?

And any feedback you can provide on maybe a better way to setup the tables?

[orange]

Under what conditions exactly did you get this message?

That corrected the first error, but now I'm getting "Microsoft Database Engine cannot find a record in the table "tblPartvalidation" with key matching fields PartvalidationId. Any suggestions on this one?

There are no records in tblPartvalidation.

[pbaldy]

You have referential integrity set to be enforced, so you can't add a record to the 4M table with a PartValidationID that doesn't already exist in tblPartValidation.

As a general rule, I wouldn't have a form bound to a query like that. The form would be bound to a single table, and subforms would be used to enter the data in the related tables.

[uaguy3005]

After I enter a information in the form under the date and fill out the issue section the error pops up.

[uaguy3005]

You have referential integrity set to be enforced, so you can't add a record to the 4M table with a PartValidationID that doesn't already exist in tblPartValidation.

As a general rule, I wouldn't have a form bound to a query like that. The form would be bound to a single table, and subforms would be used to enter the data in the related tables.

How would I set that up? My intention is to record the issue, then record what was done to validate the part (which could be more than one choice) so I made it a subform, then record who approved the change, it too as a subform since more than one person will validate the change.