Value List from Two Fields in Same Record-FM11
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:
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!