>>Not quite a bug, but a peculiarity of foxpro:
>>if you set the index to seq_no, it first tries to find an index with the _name_ seq_no. If that does not exist it will evaluate seq_no. It will then try to set the index to the result of that expression, in this case the result seems to be 1, so it sets the index to 1
>>if seq_no evaluates to "k_memo" the index will be set to k_memo (if it exists)
>>So, if you use an index name, you better use order "seq_no", if you want is as an expression use (seq_no)
>
>I still think it's a bug. If I want VFP to evaliate the name I would use a name expression.

Sergey, although I understant the argument I agree with you. I just sent the bug report to MS. If I hear anything I let everyone know the result.

Thanks to everyone for their valuable input. At least we all know what is going on here.
John