>Sometimes, when the user turn off the pc with the program opened the CDX file was broken. Then the Primary Key doesn't function and I have not unique keys. In this case I can't use the REINDEX command because the CDX is broken, and I can't use the INDEX command because I can't create a PRIMARY KEY with this instruction. What can I do ? Now I work with the pc, and use the Validate Database and re-make all the index in a manual way. Can I make a rutine to repair a CDX broken which has a Primary Key ?
>Thanks.

You may want to look into buying SDT ( I believe its Stonefield Data Tools ). As I understand it, SDT uses metadata to store information about your tables, which makes it easier to recreate tables and indexes in production code.

HTH