Conditional Value List with values from two different fields
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.