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.