referential integrity

  • Thread starter Thread starter john
  • Start date Start date
J

john

When defining relationships between tables I usually try to enforce
referential integrity- mostly without any difficulty.

Sometimes however I get this message :

Referential integrity rules have been violated..

I understand that to mean:
Presence of one or more references in the joined table to non existent
primary table records.

Do you know a way of checking the data in joined table's with 000's of
records to find the records which violate referential integrity rules.
 
Start a New Query, and choose Find Unmatched Query. Choose tables or queries
that you will compare. The first one should contain the suspected unmatched
data. Then choose field(s) to display that show the unmatched data.
 
Back
Top