Open a table that contains at least one linked field.
Use the linked field drop-down list to display the contents of a field other than the primary key
Sort the table on the linked field.
The result seems to be that the table is sorted as if the primary key field were still being displayed. This can easily give the impression that the ordering is random - and certainly isn't going to help users locate the information they're after.
Attached is an illustrative image. This field (in a bibliography database) shows the author name, and is sorted on that field - except the order the records are appearing in is certainly not alphabetical.
To reproduce:
The result seems to be that the table is sorted as if the primary key field were still being displayed. This can easily give the impression that the ordering is random - and certainly isn't going to help users locate the information they're after.
Attached is an illustrative image. This field (in a bibliography database) shows the author name, and is sorted on that field - except the order the records are appearing in is certainly not alphabetical.