>>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.
Whoops! I don't usually assume, I make sure the table is PACKed first. I'm curious what other uses there would be for the deleted status though...
kenweber
GCom2 Solutions
Microsoft Certified Professional