AnsweredAssumed Answered

Filtered value lists

Question asked by BarryIrvine on Oct 24, 2011
Latest reply on Oct 24, 2011 by crtopher


Filtered value lists



Is it possible to have a filtered value list based on another field?

For example I have a table called Event and this contains a number of events. It is possible to link these Events to a Donation with the relationship Event.event_id = Donation.event_id. In the portal for the Donations I display a drop-down list of all the event_names from field Event::event_name so that the event_id can be linked.

I would like to filter this list so that only those events where event_type = "Fundraising" appeared in the drop-down list but I can't see a way to do this.

Is this possible in Filemaker?