Hi Jerry,

SELECT InvNo,PK, COUNT(PK)    FROM CustCard GROUP BY InvNo,PK HAVING COUNT(PK)>1

MartinaJ

>what's the easier way to detect the duplicate records?
>
>table: CustCard.dbf
>Index: InvNo+PK
>
>

>InvNo   PK     
>5000    9009        => 
>5001    9010   
>5000    9009        => double 
>

>
>It should not have two records with the same InvNo+PK
>
>thanks for the help.
>
>regards,
>
>Jerry