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 many locations, and a Subdivision can have many work orders.
A Location is an address.
When I open the work order form, to add a new work order, one of the fields is a drop down of all previous subdivisions. I can select one or add a new one if needs be. Works great.
I would like to add another field, preferably labeled Location, where when I select a subdivision from the drop down menu (as detailed above), the location's drop down will only give me a list of locations associated with the selected subdivision.
However, with how I currently have it, even if I select a subdivision, it gives me all of the locations, regardless of the subdivision.
Any ideas?
Again, I am excited to see where this will take me and appreciate everyone's time and willingness to assist.
I have 3 tables: Work Orders, Subdivisions, Locations. Both Work Orders & Locations are children tables to Subdivisions. A subdivision can have many locations, and a Subdivision can have many work orders.
A Location is an address.
When I open the work order form, to add a new work order, one of the fields is a drop down of all previous subdivisions. I can select one or add a new one if needs be. Works great.
I would like to add another field, preferably labeled Location, where when I select a subdivision from the drop down menu (as detailed above), the location's drop down will only give me a list of locations associated with the selected subdivision.
However, with how I currently have it, even if I select a subdivision, it gives me all of the locations, regardless of the subdivision.
Any ideas?
Again, I am excited to see where this will take me and appreciate everyone's time and willingness to assist.
