AnsweredAssumed Answered

Value List from Two Fields in Same Record-FM11

Question asked by FM_Rookie on Apr 16, 2012
Latest reply on Apr 16, 2012 by FM_Rookie

Title

Value List from Two Fields in Same Record-FM11

Post

I have a quandary...

I have table CONTACTS with these fields:  Spouse1 and Spouse2

I have a portal based on another table, ACTIVITIES, that I want a Value List to contain:
     Spouse1
     Spouse2
     Both (or "Spouse1 & Spouse2" would also work)

I know I need to make a new TO for the value list, but don't know how to extract the values of the two fields to make the list.  I'm guessing I need to use global fields & maybe a script, but I don't know how.

Thanks if advance!

Outcomes