AnsweredAssumed Answered

Conditional Value List with values from two different fields

Question asked by angharad on Dec 2, 2009
Latest reply on Dec 2, 2009 by angharad

Title

Conditional Value List with values from two different fields

Post

I've looked through the value list documentation & posts and can't seem to find a relevant answer.  Relatively new user Filemaker 10.

 

I'm building a database for a nonprofit.  There are two reasons people give - because they attended an event, or in response to an appeal.  I have a donations table, an event table, and an appeals table.  I would like data from the "Event_Name" field in the event table, and data from the "Appeal_Name" field in the appeal table, both to provide a value list for the field "Donation_Reason" in the donations table.  Using the conditional value list box I can get either the data from Event_Name, or that from Appeal_Name, to appear, but not both.  What am I doing wrong?

 

Thanks for any help you can give.

Outcomes