OK I may be doing something wrong, so let me explain what I want to do and let you tell me if it is possible and if so how to do it because I am under a deadline and losing my mind.
I have a list called OrgList. This list contains military organizational units (Wing, Group, Squadron, and Flight)
They are in the same list. The column OrgLevel specifies which is which. There is also a ParentOrg column that is a number with the ID of the parent Organizational unit.
I have three dropdown lists. The first one (Group) needs to display the OrgName for items that have OrgLevel of 'Group'.
The second then needs to be filtered by the ParentOrg of the first drodown list item.
The Third needs to be filtered by the ParentOrg of the second item.
They will all need to display OrgName from the same list.
Now how would I do that?