I have a grid application on a table that has ID fields that I use the grid lookup automatic lookup method to display the text value associated with the ID. That all works fine, except when I make the column sortable and click the column. I expect the column to sort by the text values, not by the integer ID values. Example:
In my Grid application, the source table has ID field that I use the Grid Lookup Automatic method to display the Name value from the Lookup table. When I click on the column to sort it I would expect the sort to be:
Instead I get:
Which is the order of the underlying ID field, not the order of the Display value of the Name.