I'm working on a screen where a table will be rendered based on the user's choice of "Country" and "Organization". Both these fields are interdependent and the user needs to have the ability to choose any of the fields first.
I have currently designed them both as dropdowns:
The problem with this is that there are a lot of validations that need to be taken care of. Eg - Say a user chooses Country as India first and then clicks on the Organization dropdown, Orgs that are not present in India need to be greyed out. In contrast, if the user chooses Organization as BMW first, and then clicks on country dropdown, countries that BMW isn't present in will need to be greyed out. This, I think would be confusing to some extent. What would a better approach to this problem be? To add to it, I have never encountered such an interaction anywhere else so I also think that it would not be very intuitive to a normal user. What am I missing here?
The use case is that the user needs to have the ability to:
a) See data of All Countries that org X is in
b) See data of All Orgs that Country Y has
c) See data of Org X in Country Y
d) See data of All Countries in All Orgs