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
------------------------------
