I have three dropdowns. Dropdown1 needs to filter dropdown2 and dropdown3 in the same way. The user should then be able to interact with EITHER 2 or 3, and that selection should populate the remaining dropdown.
| Department | Location ID | Location Name |
IT | 12 | Location A |
| IT | 43 | Location B |
| Marketing | 56 | Location C |
So if I pick "IT" then I can pick either "12" or "43" from dropdown2, and it populates "Location A" or "Location B" into dropdown 3 respectively. This also needs to run in reverse, where choosing dropdown1= "IT" and then a user picks dropdown3= "Location A", should populate "12" in dropdown2.
I have gotten to the point where I have dropdown2 and dropdown3 filtering correctly when choosing dropdown1. I am stuck specifically on how to set the default value for dropdown2 or dropdown3 depending on the selection of the opposite dropdown.
EDIT: I have figured out how to get dropdown3 to populate based on dropdown2, but if I try to use the same solution for both I get a circular error
Dropdown3:
Default= LookUp(Table2,'Location ID'=Dropdown2.Selected.'Location ID','Location Name')
Dropdown2:
Default= LookUp(Table2,'Location Name'=Dropdown3.Selected.'Location Name','Location ID')
