>>I need some assistance with the deletion of duplicate records. I am working with a free table (no primary keys).
>>
>>What I am trying to accomplish is finding a prg to seek out all the duplicate values in the invoice_no field and delete them.
>>
>>can someone help me out?
>I'm not sure if this is exactly what you're looking for but it might help:
>USE sometable
>INDEX ON invoice_no TO test UNIQUE
>COPY TO newtable
Here's a variation I've used:
USE sometable
DELETE ALL
INDEX ON invoice_no TO test UNIQUE
RECALL ALL
PACK
kenweber
GCom2 Solutions
Microsoft Certified Professional