Is it possible to delete a CDX file in a table that is in a DBC and then create the index again using:

*[ADD FOREIGN KEY [eExpression5] TAG TagName4
* REFERENCES TableName2 [TAG TagName5]]


I have tried every variation of deleting CDX's and using ADD FOREIGN KEY and DROP FOREIGN KEY.

I have gotten to work as long as the CDX reccount() does not mis match the actual database.

If I get this error, is my only option to pull the database out of the DBC, then delete and recreate the CDX's and put it back in the DBC or do I need to just use something like FoxFix for VFP.

If there is an easier way to recreate a corrupted index without taking it out of the DBC, please let me know.