>>>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.

When view is created, handle it as a table:
Select View1
Index on ... tag ...
and so on. When it's going to changing sort:
Select View1
Set Order to tag ...
Thisform.Grid1.refresh