Forum Discussion

NathanAllan4's avatar
NathanAllan4
Qrew Cadet
6 years ago

Showing Child Table of Child Table on Parent Record

I have four tables. Jobs, Eng, Units, and Materials

1 Job has many Eng, 1 Eng has many materials and 1 Unit has many Eng

There is a set number of materials and each materials is already associated to an Eng (this won't change). When I go into the job though and select which Eng will be used on that job I would like to automatically show which materials are associated to that/those Eng(s) so I know what materials are being used on that job as well. I have this working already in the Eng table. Where I can select from a dropdown a unit, relate it to a job and see the materials for that Eng in the Eng record. 

How can I see both the Eng records related to the Job record and the materials related to the Eng records in the single Job record?

Hopefully I'm not being too confusing. Thanks in advance.

------------------------------
Nathan Allan
------------------------------
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    6 years ago
    Hi Nathan,

    That is something you can do, typically you would just need to make sure that you are passing down the related Job number not just to the Engineers table but then also pass it down as a look up from the Engineers table down to the Materials table so each material has a related Job on it. 

    Then on the Jobs table you create a new Report Link field type and then edit the field settings. From there you can then set up the report link to match the Record ID (or other key field if you changed the key field) in the Job table to the Related Job that now appears on the materials table. This will pull in a report of all the Materials related to that job since the Engineer they belong to is passing down its Related Job now. One trick to make it even easier to use understand is to build a report in the Materials table sorted and grouped by Engineer to use as the report for the report link so that it is nice and organized for anyone viewing it on the Job record. I hope that suggestion is helpful.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------