Prim./Sec./Tert./Quat. List sort order

[Avinash]

Consmariutaider the following case:

I have a list with 5 columns - Name, Age, Designation, Marital Status, Salary.

I want to be able to define sets of columns sortable in a particular order. For example if the user clicks on the column header of the Name column, (assume)the list should get primarily sorted on the name col. in asc. Order, the secondary sort should be on Age (asc. again), the tertiary sort should be on the Designation, the quaternary sort should be on the Salary column.
However, when the user clicks on the column header of the Age column, (assume)the list should get primarily sorted on the age col. in asc. Order, the secondary sort should be on salary (asc. again), the tertiary sort should be on the name, the quaternary sort should be on the designation column.

When the user clicks on the column header of the Designation column, (assume)the list should get primarily sorted on the Designation col. in asc. Order, the secondary sort should be on Name(asc. again), the tertiary sort should be on the age, the quaternary sort should be on the salary column.

IS it possible to define this kind of a behaviour at DESIGN time (I know it is possible at run time - ctrl + right click lets one define the sorting order at run time).


Thanks and Regards,
Avinash

[altio]

Avinash,

At Design Time you can use the "Sort Order" property of each of the columns in the list to specify the multi-column sort order.

Please see the Column section of the online help for more details.