Problem with Relationship Referential Integrity

[Radtastic10]

I am trying to finish up this database, I have appended quite a few records from an old database to a new one. However, in doing so Access will not allow me to check the Enforce Referential Integrity box for one of my main relationships.

I keeps popping up an Error: Data in Table B violates referential integrity rules. Edit the data so that records in the primary table exist for all related records.

My question is there a way that Access will show me where the discrepancy is so that I can fix the problem? Or do I just have to go through the whole database record by record in order to fix the problem?

Thanks a ton in advance

[pbaldy]

Try playing with the unmatched query wizard.

[Radtastic10]

Thank you, it brought up all the unmatched records. I will deal with those and see if that fixes the relationship issues.

[pbaldy]

No problem.