Make dynamic filters in list - choice in one filter limits choices in other filters

bontemuis

Member
I have a list with three filters: Profession, Instrument and Country. If I choose e.g. Composer as Profession, then I get a list of all composers. If I then go to Country, the filters lists all countries, while I would like to see only those countries where Composers live. E.g. if I choose Mexico for Country then no rows show up, while my goal is to never get empty lists.
I have searched for this solution many times, tried to implement the cascading dropdown plugin, but as far as I understand this isn't appropriate for my problem. So if anyone recognizes this problem and has any suggestions, feel free! Thanks in advance.

Kind regards, Hans
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top