>>Hi,
>>
>>I have a weird situation as following:
>>
>>A table belogs to a database. Table has fields MyField1, MyField2 (and a couple more). When I open this table in the Command Windows (and use Modify Structure) the table shows just one index, on MyField1. Yet when I issue command
>>

>>set index to tag MyIndex2
>>

>>
>>I get no error. And it seems like the order of the table changes. Where could be the index tag on field MyIndex2 if I don't see it in the Modify Structure window?
>>
>>UPDATE. I noticed just now that the status line of the VFP IDE shows the following (as soon as I type SET INDEX TO TAG MyIndex1):
>>
>>Master index: MyTable.cdx Tag: MyField1
>>
>>That is even though I set the index tag to MyIndex2, VFP actually sets the index tag to MyIndex1.
>>
>>Could anybody explain this? TIA.
>
>Use SET ORDER command, not SET INDEX. SET INDEX does something else.

I am sorry. I mistyped. I do actually type SET ORDER TO TAG MyField1.