AnsweredAssumed Answered

Can I Look at Data 2 Tables Away Based on Sort Order 1 Table Away?

Question asked by richardsrussell on Sep 21, 2017
Latest reply on Sep 22, 2017 by philmodjunk

So here's a very sketchy entity-relationship diagram of my file:


E-R Diagram.jpeg


From the vantage point of a record in Table W, I can set up a portal that shows me all the related records in X, based on the relationship WX:


Portal Normal.jpeg

And I can specify within relationship WX that I want Table X to be sorted in reverse chronological order, with the most recent records on top, and the portal will do that for me:


Portal Sorted.jpeg

But really, I only want to work with the very most recent record, so I do away with the portal altogether and just display the data from the top record:


Top Record.jpeg


I also want to work with the data from 2 tables distant that X4 is related to:


Remote Tables Desired.jpeg


But what I get instead is the Y and Z records related to the first record in X, not the one I want:


Remote Tables Actual.jpeg


It appears that Tables Y and Z do not respect the sort order I set up in Relationship WX.


Is there anything I can do about this, or am I just SOL?