OK, now there is a clear question.
When you go go McDonalds, they will try to sell you the full meal deal. Burger drink and fries. That is similar to a relatinship where it comes with the relationship so lookups, and the report link field on the left side to let you have an embedded report of children on a form, and also the Add Child button.
But you can also just go to Mcd's and order just fries.
So just go ahead and create a Report Link field on your Jobs table. On the left side of the field config you will set that to be to be the [Record ID#] field. Then make sure that you look up the field typically called [Related Job] from the middle level table ENG down to the grandchild level table Materials and call it what it is [Record ID# of Job]
use that field to complete the configuration of the report link field on the Jobs table.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
