Just thought I'd point out for that you will have to do your seeks on the same expression as the index.

ie. seek(' 1 7') won't work. but seek(' 1 993') will.

Ok.
Bye.

>Thank you Craig. Thats the way he is currently doing it. We are just looking into switching from 2.6 to 7 and he was wondering if there was a better way to do it in the new version.
>
>Chris
>
>>Sure can. INDEX ON STR(Part_No) + STR(1000 - wo_no) TAG MyTag.
>>
>>You'll need to use a number larger than the biggest wo_no for 1000.
>>
>>>Hi,
>>>
>>>My boss wants to know if you can create a index with two 'sorts' in Visual FoxPro. For example,
>>>

>>>index on part_no ascending + wo_no descending
>>>

>>>So it would look like this:
>>>part_no wo_no
>>>1 7
>>>1 5
>>>1 3
>>>2 3
>>>2 2
>>>3 7
>>>3 3
>>>
>>>I do not think its possible. (looking at the help file it looks like you can only sort it ascending or descending for the entire index)
>>>
>>>I already suggested he could write an SQL statement and order wo_no descending and then create an index to set part_no ascending but he would prefer to do it this way.
>>>
>>>Thanks!
>>>Chris