I’m having a problem that I cannot seem to find an easy answer to: We have multiple “heats” of racing (Qualifying, Heat 1A, Heat 1B, Heat 2A, Heat 2B, Heat
Heat 3A, Heat 3B, Final Heat) with multiple drivers in each.
I have a table view that is grouped by heats, then by result in that heat, which does exactly what it supposed to do. So far, so good.
The problem comes in sort order in the Table View: it sorts by alphabetical order (Final, Heat 1A, 1B, 2A, 2B, 3A, 3B, Qualifying), which is not the chronological order.
I have added another column (heat order), giving each heat a number, so Qualifying is 1, Heat 1A is 2, Heat 1B is 3, etc., but I CANNOT get the table to sort by that “Heat Order” field, no matter what I do! It will ALWAYS sort alphabetically!
Any ideas of what I’m doing wrong?