Thanks, Dragan

Yeah I've used genDBC for this purpose in the past. My reservation is that the last time I generated a program to build my database for a client, in VFP7, the result didn't work (It had worked fine for me in the past in VFP3).

Anyhow, the problem has been resolved now (see up in thread). Thanks again for your input.

Terry

>Check the code generated by Gendbc - you have the code for setting the relations there. And to remove relations before indexing (so your dbc would still be valid while you're manipulating indexes), you can edit a copy of those lines to DROP FOREIGN KEY before you do your indexing. Tried, works.
>
>The only trouble is when the indexes or FPTs are so thoroughly screwed that you can't even open the table; in such a case, only a serious tool like SDT, or some serious hacking can help.
>
>Sometimes, a table with a fpt-gone-south can be saved by copying the data to a temp table, zapping, and appending from the temp. Doesn't work each time, probably covers only the case when the error is on an unused block.