Event Attendance Tracking

This topic is locked

Event Attendance Tracking	11/28/2010 6:08:21 PM
PHPRunner General questions
N nzmark author I would like to keep track of meeting or event attaendance of my members but am unsure of how to do this and cannot find anything in the FAQ. I would like to create a new table called event and be able to add to each event the memberid for each memeber that attended from a select or multi select drop box. E.g wehen entering a new event select the members that attended fropm the member table. Any help with this would be much appreciated.


	Sergey Kornilov admin 11/29/2010
	I think you can create a new Attendance table with fields like ID (autoinrement), EventID and MemberID to keep track of who attended what. You can setup master-details relationship between Events (master) and Attendance (details) to quickly manage attendance data. Another approach is to setup a multiselect dropdown box to store attending members for each event there. You don't need a new table in this case however this will be more difficult to manage if you have a large number of members.