Sort by table by field's ViewValue not CurrentValue

[philmills]

I have a table that I'm trying to set default sort order for field1 which contains ids. The viewvalue is a lookup value from another table based on the id.
However, the table seems to be using the field's CurrentValue for sorting rather it's ViewValue.
How can I change that?

[philmills]

I ended up adding a custom field which looks up the name from the other table
The original field is hidden in list view, so I can now sort the table alphanumerically by the custom field.

Is there an easier way?

[arbei]

You may use Lookup Table -> Allow sort/search.