Problem with referential integrity

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Somehow the relationship between two of my key tables as been deleted (one to
many relationship). I've tried to recreate it, but I'm getting an error when
I try to enforce referential integrity which says data in the related table
violates referential integrity, but I can't see where the problem is (there's
currently only 28 records and it all looks ok to me)

Is there a wayI can identify the record/s that are causing a problem?

Thanks for your help
 
The error implies that you've got a record in your child table trying to
point to a non-existent record in your parent table. See whether using the
Find Unmatched Query Wizard helps.
 
Worked perfectly. Thank you

Douglas J. Steele said:
The error implies that you've got a record in your child table trying to
point to a non-existent record in your parent table. See whether using the
Find Unmatched Query Wizard helps.
Click to expand...
 
Back
Top