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?