Showing attributes in a child - indirectly related - entity

[timmothyquist]

Hey all,

What I want to achieve is to display attributes from indirectly related parent entities. In this case I want to get the name from the customer and add it to the JobOrder table. They are connected to eachother through the Order table. I have tried doing so by selecting the customer name attribute through a JobOrder view, but I can find no way of adding the Customer name as a column in the JobOrder table once I generate a screen for this view.

I haven’t done this before and any help would be greatly appreciated!

[timmothyquist]

I found out you can just go to the foreign key and put a dot there to get all the attributes from the foreign table . Never realised this before.