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)

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