1 Reply Latest reply on Oct 24, 2011 7:54 AM by crtopher

    Filtered value lists



      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?