Am I on the right path? Looking for bread crumbs... : )
I have been using FileMaker Pro 11 and would like to to "re-design" our old existing database to add features. But, I am running into problems and could use some guidance.
The basic concept is that we offer multiple camps "events" and need to manage the "event role" (students, teachers, counselors, etc). We would like to track the history of a participant "contact information" with a list of all events and rols they have maintained. For example, a person can attend camp as a student for several years, then attend as counselor and then teacher. The data collected for each "event" and "role" changes but the contact information stays the same and builds a history.
I believe I need the following tables:
Camp Managemant (Events), Contact Information (Participant), Student Registration (Role), Teacher Registration (Role) and Counselor Registration (Roie).
Am I on the right path?