>The table item C(15) and location C(4) and the client would like the picklist by ascending item and descending location.
>
>Can it be done via indexing with VFP6?
See
Creating a compound index with a descending portion Thread #
1053896.
Though I agree, that it would be easier to use SELECT-SQL command.
If it's not broken, fix it until it is.
My Blog