Forum Discussion

AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
7 years ago

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

Hello!! First post. Excited to see where it takes me. I have 3 tables: Work Orders, Subdivisions, Locations. Both Work Orders & Locations are children tables to Subdivisions. A subdivision can have...
Forms
Relationships
Tables and fields
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
7 years ago
From how I'm reading it - Locations will have many work orders so Locations is your parent table. As you stated, over time, you could have hundreds of works orders at that same location, so Work Orders will be the child table. 



Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
7 years ago
Chayce, Thanks a ton for the info and the link to the blog!! Read through it, made a ton of sense. Thanks again!!