I want to understand how to use List() and GetNthRecord() with related records to access data from fields two tables down the child relationship. It seems that nothing seems to make sense using GetNthRecord with these.
Flights -< FlightLegs -< AirportTerminal_ArrivalAirport
The only way that I can use GetNthRecord () or List() to display the related records properly is by creating a calculation field in the first child table "FlightLegs" and then using these functions on the calculation field instead.
Why can't I access the records from the grandchild table directly with these functions?