Searching, saving and displaying 1...n contacts and their affiliations
I am using FilemakerPro 12 to develop a database for a performing arts organization to track event attendance, donations and volunteer time.
The database will track contacts and their affiliations. There may be one or more contacts per affiliation. The affiliation may be a couple, church, school or some other grouping.
Affiliations will be stored in the AFFILIATIONS Table. The primary key will be AFFILIATION_ID
The contact information will be in the CONTACTS table. The primary key will be CONTACT_ID. The table will have a foreign key AFFILIATION_ID.
Question 1. What control should I use to display 1 or more contacts?
Question 2: Can I use the same layout for searching for existing contacts and creating new contacts. The behavior I want is for a user to enter a name, and if it is found, show all the contacts in the affiliation. If no contact is found, a new affiliation and contact will be created.
The found or new contact needs to be selected for recording of donations, reservations, or volunteer hours elsewhere in the UI.