>Hello
>
>My problem is this one :
>
>Before in Clipper or Dbase i have this king of index :
>
>STR(NO_RELAT,6)+DESCEND(DTOS(DATE_COUR))
>
>and know in VfoxPro6 i just can make a index ASCENDIND or DESCENDING
>but on all the key and not just on a field of the key
>
>Can ou told me if someone can resolve this problem ??

see MS KB article Q90412 and Q92553
if you are using views or SQL cursors then you can sent ascnd and descend status for each field involved in the order

Arnon