I have to sort records in a table using muliple sort fields - F1, F2, F3 in below sequence -

1) F1 ascending
2) F2 descending
3) F3 - pre determined list (another table where values of F3 are assigned sort order values.

I am unable to think of a way to do the 3rd. Do you guys have any tips?

Sometimes it's a lot easier to add a string field that does the complete sorting process. (That field has to be filled within the session script according the required sorting sequence.)

But there are some caveats:
1. Sorting asc/desc mixed; work-around for integers: 9999 - value ...
2. grouping within the report

I think you've seen that in some reports.

Günther

Can you elaborate better your question? And,this sort it is on a script or a report?

If for example day list {Mon,Tue,....} or month list is field F3 in a pre-determined list , assign them a number and use the same in asc/dec manner . Baan Enum fields are one such lists pre-determined order.

Thanks guys for the help. I tried the suggestion and it works.