>Are all the indexes getting dropped, or just the PK? I have had instances where a PK got corrupted, and I had to manually edit the table and enter valid PKs for the corrupted records. Then SDT was able to recreate the PK using the SDT Meta Data. I was able to do this because I also include a runtime command window style editing form in my apps. It only becomes available on the menu if I log in to the app using a master user ID and password.
>
>If this corruption is occurring often, there is probably a network or connection problem.

Mark;
Actually all the indexes for two of my tables (unrelated tables) got dropped. I had a problem in the code of one of my screens which allowed an invalid record to get stored (it didn't violate the PK but one of my other indices made it a duplicate unknowingly - so that shouldnt have 'caused' the problem. The other table may have been open at the time. Since the app is new and this client is the first to use it I am concerned, since I am new at VFP (used to code in only 2.6) and don't want a problem to crop up that I don't have an efficient method to correct.

Sandi.
'