If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CREATING A DATABASE
Is there a good template for making a fire department activities attendance
database? I have a membership sign in sheet and would like to track how many fires, drills, meetings, and extra credit assignments they have attended for a query of all categories individualy and firefighters seaperately. |
#2
|
|||
|
|||
CREATING A DATABASE
People
- person_id - Priamry Key - first_name - last_name Event_Types - event_type_id - Primary Key - event_type_name Events - event_id - Primary Key - event_type_id - Foreign Key - references Event_Types(event_type_id) - event_name - event_date Attendance - Primary Key = (person_id, event_id) - person_id - Foreign Key - references People(person_id) - event_id - Foreign Key - references Events(event_id) This structure stores the information about the people in the people table and the event info in the events table. If someone attended the event then there would be a record in the attendance table. I would create a form based on the events table. On that form would be a subform based on Attendance that is linked to the main form on event_id. On the subform would be a drop down list to choose a person. Cheers, Jason Lepack On Sep 28, 9:11 am, ED wrote: Is there a good template for making a fire department activities attendance database? I have a membership sign in sheet and would like to track how many fires, drills, meetings, and extra credit assignments they have attended for a query of all categories individualy and firefighters seaperately. |
Thread Tools | |
Display Modes | |
|
|