Hi all, I have a portal that is based on a relationship as follows
Left side is a global field with a list of recordIDs:
"ShowIDs"
eg.
3
2
1
etc.
Right hand side is where that field is related to the foreign ID.
works perfect but is there any way of sorting that relationship to display the records in the same order as the IDs appear in the left side field.
So above they would be sorted by record ID
3,2,1
If you want them sorted in descending order as shown in your example, then yes, you can double click a relationship line to open a dialog where you can specify a sort order for related records. A portal can also have a specified sort order.
But if the ID's listed might be arranged into an arbitrary order in the global field and you want the related records to match that arbitrary order, then no, this is not possible as a relationship property. The order of the listed IDs in the global have no effect on the order of the records in the related table.