>I want to re-create my index's with INDEX ON TAG commands in VFP the problem with this is as soon as I do it I lost all the Referential Integrity. I don't like the Reindex command because what happens with a corrupted index?
>
>Charles
Charles
First run GENDBC (a PRG in your VFP\TOOLS\GENDBC folder). This will give you a PRG with all of the information held in the DBC. With a little judicious cutting and pasting you can write a PRG which will reindex your tables keeping the Primary indexes (with ALTER TABLE) and other links intact.
HTH