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?