AnsweredAssumed Answered

Filtered value list question

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

Title

Filtered value list question

Post

     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.

     Michael

     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…

Outcomes