Linked records are ordered by sequence
I can confirm that entries in the linked column are ordered by the sequence they are linked.
That means, no matter how you sort Table2 the sequence of “003”, “002” and “001” will not change.
In the case of “Hulk”: “003” was added first, then “002” and finally “001”.
Currently, there is no way to change this sort.
Use “Findmax” to get the latest or earliest date
a possible solution would be to use lookup “findmax” to get the latest dates from the linked records. Here is the example:
This is Table2:
This is Table1 with findmax column:
This is how the findmax is configured:
This is probably a solution to your requirement.
Best regards
Christoph
