>Greetings
>I am attempting to create an index that is both ascending and descending components.
>
>Vendor has to be ascending, PO has to be descending. I tried variations of:
>

>INDEX on vendcode ASCENDING + ponum descending tag vendpo
>INDEX on vendcode + ponum descending tag vendpo
>INDEX on ascending(vendcode) + DESCENDING(ponum) tag vendpo
>SET ORDER TO VENDPO vendcode ASCENDING  ponum descendng
>SET ORDER TO VENDPO vendcode, ASCENDING  ponum descendng
>

>
>This should be a no brainer, but I can't get the syntax correct.
>
>Any Ideas out there???
>
>thanks, Vince

What are the types of the fields? If both are character, it's actually a bit tricky, though Fabio proposed a great solution a while back.