Hello, guys, I have a table employees, of list of employees sorted by activated and deactivated. Want to create a dropdown list with only the activated workers.
For such cases, I use a type of conditional value list that I call a "hardwired conditional value list" as the script design specifies the "category" used to filter the value list instead of the user making a selection.
See "Adventures in FileMaking #1 - Conditional Value Lists". This is a free database file that you can download. It demonstrates 10 different conditional value lists including two different ways to set up a "hardwired" conditional value list with detailed info on how each works and how it was set up.
Retrieving data ...