I am building a membership database for an organisation which has family members in it. The things we need are an address list and a roll that records who attends each activity. This is an ongoing exercise.
I have a table called "tblFamilies" with the primary field called "familyid". It also has fields for addresses, phone etc for the households.
I have another table called "tblPeople" with fields called "peopleid", "familyname" (drawn from "familyid" above), "pfn" (firstname).
I want to create the phone list so that it shows the surname, man's name, woman's name and children's names alongside each other and the home address.
I want attendances to be easily recorded. Preferably so that all individual's names appear in a column with the activity alongside. Attendance needs to be tracked so we can follow trends.
How do I do this so that we can can have a well presented phone list and an efficient means of recording individual attendances at activities?