AnsweredAssumed Answered

Filtered value list question

Question asked by deathrobot on May 20, 2014
Latest reply on May 21, 2014 by deathrobot


Filtered value list question


     I have a question about filtering a value list. I have the following tables:


     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:


     Where AFM::Global = DESCRIPTION::id_Category

     I thought using a value list based on this relationship should limit the results, but…it doesn't…