data not matching between related tables

[Slez via AccessMonster.com]

A while back, I encountered some corruption, and didn't realize that Access
eliminated my relationship between the parent and child table. When I try to
reset the relationship, it won't let me because some data violates the rules.
I'm pretty sure that one or more records in the parent table was deleted
along the way leaving the related records in the child table there.

Since scrolling through 30,000 records to try identifying what might be
missing isn't practical, I thought I'd ask if there is a way to create a
query that identifies the "orphan" record(s). Or perhaps a query isn't the
preferred method.

Any suggestions are appreciated!
Thanks in advance!

 

[Michel Walsh]

There is a query in the query wizard that does just that, finding unmatched
record.

Add cascade delete to avoid that problem, if that makes sense in your
situation: if a parent get deleted, all its children will be also
automatically deleted.


Vanderghast, Access MVP

 

[Slez via AccessMonster.com]

Thanks for the reply! I'll give that a try. I had cascade delete set, but
as mentioned, the corruption issue deleted the relationship.

There is a query in the query wizard that does just that, finding unmatched
record.

Add cascade delete to avoid that problem, if that makes sense in your
situation: if a parent get deleted, all its children will be also
automatically deleted.

Vanderghast, Access MVP

A while back, I encountered some corruption, and didn't realize that Access
eliminated my relationship between the parent and child table. When I try

[quoted text clipped - 12 lines]

Any suggestions are appreciated!
Thanks in advance!