Displaying values in Main Table from multiple rows of Child Table (based on Dropdown)

[Ryan_Mortimer]

Hey everybody! LONG time user, first time asker so I am hoping that somebody can point me in the right direction.

I am having some issues trying to display some data from a child table in my app.
I have done some digging around and I can’t find a solution, but I may be looking in the wrong areas.

I have a multi-destination booking app as the deliveries usually make a few stop overs.
In the main table/view, I have a column setup for Next Pick Up Address and Next Drop Off Address where I will need to display the relevant information from rows in my child table.

For example:

LEG 1
PICK UP FROM - 1A Fake Street, New York
DROP OFF TO - 56B Example Avenue, New York
STATUS - (Booked/In Transit/Completed)

LEG 2
PICK UP FROM - 56 Example Avenue, New York
DROP OFF TO - 1162 Sample Street, New York
STATUS - (Booked/In Transit/Completed)

If status = Completed for the first leg, I need the column(s) to show the information from the Leg 2.

Additionally, if possible, it would be great to be able to show the information from the FIRST Pick Up location and the FINAL Drop Off location displayed in their own columns as well.

I’m not sure if I am meant to do this via a workflow (by changing the values based on a set of rules) or if it is easier to do this through an expression.