Assuming that part_no is N(9) and wo_no is N(7) (Substitute with actual field size).

INDEX ON STR(part_no, 9) + STR( 9999999 - wo_no, 7)

>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