>>For some reason, I'm stumbling trying to figure this one out, so I'm looking for suggestions.
>>
>>We have a file of interest rates which we are currently indexing on:
>>

BankCode+DTOS(ValueDate)

>
>

BankCode+padl(date()-ValueDate),10)

(last number could be less, depending on how old your data are)
>
>>
>>Our form class makes use of this primary tag to properly populate our 2 combo boxes for the 2 key fields for the user to choose the right record from. We have a user that wants us to change the intial display to be based on the most recent date instead of the first date for the corresponding bank code.
>>
>>So, the question is: how do I create an index expression that produces an ascending sort of the bank code and a descending sort of the date? We can't change the form to use a view or SQL cursor because that would be too huge an overhaul for this one item. :)
>>
>>TIA
>>
>>Laterness,
>>Jon