Thanks for help. I used the following and it works:
INDEX ON code1+code2 to code
But another problem is that the "code2" is a character but not numeric.
So it will show ---
BBB $30 1 1
CCC $20 1 11
EEE $10 1 12
FFF $20 1 2
I have tried:
INDEX ON code1+ val(code2) to code
but it said it is a "misoperand error". I need to use character for the code2 in some purpose, so what can I do?


>>Dear all,
>>
>> I have a table (Name, cost, code1, code2), I want to index it 1st in the code1 then at code2. For example, if it has:
>>DDD $10 2 1
>>AAA $20 2 4
>>BBB $30 1 1
>>CCC $20 1 2
>>After indexing, I want to have the following showing in a Report:
>>BBB $30 1 1
>>CCC $20 1 2
>>DDD $10 2 1
>>AAA $20 2 4
>>I tried ---
>>index on code to table2
>>index on code2 to table3
>>set index to table2, table3
>>But it does not work. Please tell me why or suggest a better way to do that.
>>Thanks
>
>How about INDEX ON code1+code2 TAG code?
>
>HTH,