Thanks also. I was really scrambling to get the info since I had to get the system back on line quick. I can't think under pressure too well.
Allen


>>Thank you. It's clearer and works but I needed another thing...
>>What you gave me shows the duplicate record and the times it's duplicated, but I was trying to get the duplicate records, record by record. So that each record is listed.
>>Thanks,
>>Allen
>
>What Sergey offered, is a standard way to find duplicates. You could easily do a Set Relation to lineitems_id into your detail lineitems table and get each record, or you could do a second query for all lineitems_id in the duplicates cursor you got.