AnsweredAssumed Answered

filtered valuelist with "show all" option

Question asked by p528 on Jul 31, 2017
Latest reply on Jul 31, 2017 by TomHays

Hello experts. I'm stuck on a problem.

Here is what I like to achieve:

I have to tables: COUNTRIES & CITIES

The COUNTRY table has 200 country records with a status “active” or empty.
In the CITIES table, I have a drop-down with countries from the COUNTRIES, showing me only the “active” countries.
I’d like to add a “show all” checkbox to the CITIES table, in order when checked to see all countries in to drop-down.

I found this interesting blog, which could lead to solve this:

Filtered Value Lists, with “All” Option | A Filemaker Miscellany

Unable to recreate this, I hope to finde help here.

Anybody out there who knows how to do this?

Outcomes