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