Is there a way to definitively define the sort order when linking to an existing record on a “Link to another record” field type?
Let’s say we have “Table 1 (T1)” and “Table 2 (T2)”. On T2, I’ve created a linked record to T1. I’ve created a view on T1 with the appropriate sorting order (in this case, “date modified”). On T2, I’ve selected this view on the “Limit record selection to a view” setting. When I go to associate / start entering my query and filtering records from T2, it seems the order is not predictable, and certainly, not sorted by the “date modified” as I had defined in the T1 view.
Any ideas how to maintain sort order from the T1’s view?