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.