Howdy,
I'm building a form that has a drop down menu of parent organization names (Org1, Org2, Org3, Org4) in a column in the current list upon which the form is built. Each organization has n-children. Example Org1 may have a three children, Org2 may have 10 children, Org 3 may have one, etc. I have a mapping of parent Org names and children Org names.
What I want is when a user selects from a drop down of parent Org names (e.g., Org1) that they are then presented with a checkbox control that has all of the children of Org1.
Parent Org1 names and the mapping can be in another list if it's necessary but I'm not quite certain how to go about doing this. The parent Org names and the child Org names get updated/changed multiple times a year so I only want to have to change one source. If it wasn't clear the data is tidy. I.e., parent:child is Org1:Child1, Org1:Child2, Org1:Child3, Org1:Child4, Org2:different_Child1, etc
Any help would be greatly appreciated.