I am trying to create a dynamic filter based on 2 columns. I have a “Bars” table with columns Bar, City, Country and another “History” table that records all of the bars that I went to.
What I am trying to do is to select the bar based on the country and the city. Selecting the country, the city and the dropdown should automatically show me all the bars in that country and that city.
Is there a simple way to do that ?
Just want to add…you are writing three choice components to the same column. For this to work correctly, you are going to need to also write the country and city to your history table as well. Otherwise your three choices are going to conflict with each other since you are setting them to the same bar column.