Showing Child Table of Child Table on Parent Record

Question

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

MarkShnierYou · Answer

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

Sign up

Login to the community