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 material 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? (Form view)

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

------------------------------
Nathan Allan
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Truthfully, your post is confusing.  With what you posted as a preamble, can you clearly state your actual questions(s). 

    I can not tell if you are looking to auto create a set of child records, limit a Conditional Drop Down to valid choices,  or just to show grandchildren records on a grandparent  record.

    ------------------------------
    Mark Shnier (YQC)
    markshnier2@gmail.com
    ------------------------------
    • NathanAllan4's avatar
      NathanAllan4
      Qrew Cadet
      6 years ago
      Sorry about that. Appreciate your help. I want to just show grandchildren records on a grandparent record.

      ------------------------------
      Nathan Allan
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        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
        ------------------------------