I have a table with Region, Country and Account. Would like to create Dependent/independent dropdowns for each in a way that:
- I have the 3 of them always visible (with a standard dependency the second dropdown would become visible only when I select an element from the first but this is not the desired behavior)
- I can select any possible combination of them (For example select only the Country, or a combination of Region + Account)
- Depending on each dropdown selection, have the other two limit the values displayed based on the value selected (for example if I do not select any Region from dropdown1, but I select a Country from dropdown2, I want to get the Account values in dropdown3 and also the Region values in dropdown1 be limited based on the country selection) .
Any way I can achieve that?
Thanks in advance for your help