I have a table where a select field is an integer which is an index to a text value via a lookup table.
In List view, how do I get it to sort by the displayed 'looked up' text value rather than by the actual integer field value?
I have a table where a select field is an integer which is an index to a text value via a lookup table.
In List view, how do I get it to sort by the displayed 'looked up' text value rather than by the actual integer field value?
You may enable Lookup Table -> Allow Sort/Search.