Hi Chuck
>Are you using unique indexes? I have to say I haven't used one in my 7+ years of using FoxPro and VFP.
The only reason I use unique indexes is to remove dublicates from the table and it doesn't matter which of the dublicates remain.
1. Create a (temporary) unique index on the expression that should be unique.
2. Delete all records and recall only the record that are used in the unique index.
3. Drop the unique index
Regards,
Frank Camp