Hello good morning
I have a table which has a column that uses a foreign key, and I have it set up so it displays the text value from the foreign table.
I want the records to appear sorted from A to Z, but if I go to the table setup and sort the table using the column, it works but the sort works based on the ID number and not the text value.
Is there any way I can make this sort work with the text value of the foreign table?
thanks!