And AFTER I did the restore, I went into Explorer and changed the PRG default from 'run in VFP' to 'Show with WordPad'. Bleaah.... Ruined my Monday.

>Hi Barbara ------
>
>Hahaha!!! I just did the EXACT same thing the other day :)
>
>
>>
>>For a non-primary index, just use INDEX ON .... TAG ....
>>
>>If you really need to use the ALTER TABLE syntax, then run GENDBC on your DBC and look at the code generated. It will give you the exact syntax.
>>
>>Warning: Move the code generated by GENDBC very far away from your data tables. If you run it by accident (double-clicking in Explorer, for example) you will empty ALL your data tables!
>>
>>Barbara (who just finished restoring from a backup after double-clicking a GENDBC file)