How can I pull data into a child table from the parent's other child table?

Assuming you have it set up that Locations have many work orders via relationship- you can edit your reference field - Related Location to be a conditional dropdown in the field settings and make the selection of the location conditional on what you've already selected in sub-division. Its pretty straight-forward to set it up via this conditional dropdown setting to only show locations related to that subdivision



Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base