Filtered value list question
I have a question about filtering a value list. I have the following tables:
PEOPLE ---< DESCRIPTION >--- CATEGORY
There are several categories, one of which is "musician"
I am now working in a layout where the tables are:
AFM ---< RECORDED >--- PEOPLE
There is a field on the AFM layout with a value list showing records from PEOPLE. I would like to filter that list to only show people whose category is "musician." I know I have to somehow filter through the DESCRIPTION table, but I've tried MANY combinations, and can't seem to get this to work. Any help would be greatly appreciated.
EDIT: I also tried creating a global field in AFM with the id for "musician", and a new relationship like this:
AFM ---< DESCRIPTION >--- PEOPLE
Where AFM::Global = DESCRIPTION::id_Category
I thought using a value list based on this relationship should limit the results, but…it doesn't…