Display fields from 2nd degree connection


I have a technical question about connections I was hoping you could help me with.

Let’s say I have 3 tables: Material_batches, Manufacturing_lots, Products.

Many products are manufactured together (in a lot). A manufacturing lot is characterized by the material used which is produced in batches.

Material_batches is connected to Manufacturing_lots (one to many), Manufacturing_lots is connected to Products (one to many).

Material_batches —< Manufacturing_lots —< Products

I would like to display this view:


But it does not seem possible because the “Material” field is obtained from Material_batches which is connected Manufacturing_lots, which is then connected to Products.

Is it correct to say that it is not possible to display fields obtained from a “second degree” connection?

Can you please me know if I am mistaken or if there is a workaround for this?

Yes! I’ve run into similar. To get around this I have:
A) Created tables, starting with the ‘second degree’, which show the ‘first’ and ‘third’. &
B) Created a displayed a Text Formula which in the order I want, and have the table display this Text Formula, instead of the three columns. (Note: This will not work through a many-to-many connection.)