Changing sort order of database rows

[Sam Jones]

In worksheet database columns, we used to be able to drag the sort icons from column to column to change which rows were sorted when.  That doesn't seem possible now.  Am I missing something?  Hopefully there is a new way to do this without having to delete all the sort indicators first.

[Pat Stanford]

It looks like to change the sort order you do have to change to None and then add in the new order you want. You can get to this by right clicking in the database header row. You don't have to click the little tiny disclosure triangle.

 

But if you delete the first, at least they renumber while keeping the same order.

 

How many sorts were you usually using before?