Portals from Multiple Fields but the same Value List
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