>Hi,
>
>Sometimes I use unique indexes to repair a table that has a corrupted primary or candidate key: different records with the same key exist. This can be repaired by creating a unique index with the same key expression, then deleting all records in the table, then setting the order to the unique index and recalling all records. Then you pack the table to remove the double records and remove the unique index. This works quite well and easy.
>
There are other ways to do this. Getting duplicate key values from a table is a simple SQL SELECT statement, and another statement afterwards can be used to delete all but one...
Erik Moore
Clientelligence