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.
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.