>>How can I have multiple sort orders on my view? I have a grid on a form, which is view, where I need to offer the client a choice of selecting multiple sort orders.
>>
>>As for as I know, we can only have one sort order per view. Does this mean, I need to create one view per sort order and switch view when the user switch the sort order?
>
>If your view is reasonably small, you can create different index tags which will allow multiple data presentation in grid.
My view is 400 records. But, how can I create multiple index tags for a view. In the CREATE VIEW definition, there is only one ORDER clause possible.