I have a database of travel retailers, only 11 in the database for now, in 10 countries. You can search for a retailer by country using a dropdown for that, but that then gives the full list of all the countries that exist, including the ones where no retailer has registered yet. I need the dropdown to only show the countries that have travel retailers already registered (10 in this case). I can’t find out how to do that, can it be done at all? Using next-gen app.
You can do this but you need your data structures to be set up to do it.
The Country needs to be a connected table, not a field in the Travel Retailers table.
Then you would add a connection to Travel Retailers to Country. In the Country table, add a SUM field which counts the number of connected Travel Retailers. And in this search form, add a filter for that Country field to only show Country where counter is non zero.
I can see how that would work, thanks for the reply, @LeighBerre96926 . I’ll try that out (Country is a connected table).
FYI I tried to do this in next gen builder and couldn’t work out how … so used to classic screens. So I changed builder style to classic, made changes, then set back to Next Gen and it worked as expected.
Thanks for the update - I’ll try that too then (wasn’t getting anywhere yet).