0 Replies Latest reply on Oct 12, 2015 6:59 AM by rickaltman

    Filtering a drop-down list

    rickaltman

      I would like to enter evaluations from patrons of a recent conference and would like to create a drop-down list of those who attended. It's easy enough for me to create a drop-down list of the first and last names of those in our database, but that is a superset of over 12,000 names -- that's a pretty lengthy list!

       

      I know there is a way to filter that list to show only the 220 who attended our recent conference, but I do not know how to create that relationship. To provide a few details:

       

      - The parent table is called Patrons and the fields are First Name and Last Name

      - Conference patrons are in a related tabled called Activities and the conference name of Presentation Summit 2015 is in a field named Event.

      - I am using FMPA 12.

       

       

      Thanks in advance for any help.