>>>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
Clever variation. The limitation of it is that sometimes we use the deleted field(?) for other purposes and your method assumes no records are previously deleted. Really deleted is just a free logical field. Free in that you have to pay for it in space whether you use it or not.