Filtered value list
I am creating a value list pulled from another Filemaker Pro 13 file. I am using the field "Artist" which works file. What I'd like to do is show only artist from the "Artist" field that have the status "Active" in the Status field. Is there a way to filter this value list?
If I add a status field in the original solution and create a relationship to the external file, I can "include only related values from." I'd rather not have this additional field if there is another way to achieve this.