>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

Not tested, but something like this should work.

SELECT FKeyToMother, FieldToCheck, COUNT(*) AS Dupes ;
  FROM Daughter ;
 GROUP BY FKeyToMother, FieldToCheck ;
 HAVING Dupes > 1 ;
  INTO CURSOR Dupes

Regards,