I have two tables in a mother-daughter relationship. I want to scan through the mother table looking for duplicate records (just need to compare one field) in the daughter table. Is there a slick way to do this?

Thanks very much,
Stan