AnsweredAssumed Answered

Portals from Multiple Fields but the same Value List

Question asked by Charmalique on Aug 21, 2014
Latest reply on Sep 3, 2014 by Charmalique

Title

Portals from Multiple Fields but the same Value List

Post

      Hi,

     I am newbie with Filemaker (Pro 9). I am stuck in creating portals. I have 2 tables. The first table has 5 special fields that uses the same relationship (value list from table 2). The first table has names. The second table is colors, red, blue, green. (this is an example only). 

     In my first table with names, i have 5 fields (for color 1, color 2, color 3, color 4 and color 5). The five fields have a drop list from table 2.

     So when i create a portal. I want the names of the person to be in the row who selects the color red. In which they might be in fields color 1, color 2, color 3.

     My current portal results to the names who are in field color 1 and not include in field color 2, color 3, color 4 and color 5.

     Can you please help what to do? Thanks

      

      

Outcomes