Drop Down list as a filter ... for records

Discussion created by ezeitgeist on Jul 4, 2016
Latest reply on Jul 6, 2016 by ezeitgeist

I have a set of a thousand records. Within a single record are 3 different fields that are drop-down lists of a select value.


Is there a way that I can have 3 global fields, each a different one of the drop-down lists (default set to ALL), and when one value is selected in a drop-down list, the results show just those with those values? I have read about doing this in a portal, BUT, how do you do this when there are no related records, it is all records within one single table? Do I have to create a table with the drop-down list values in it and then relate them or something?


Thank you ahead of time!


PS I am using Filemaker 12 Pro Advanced.