>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,
>AllenWhat 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.