Index
» Projects
» phpMyEdit
» Forum
» Do I need a temporary table to do this? |
|
foxylady337
Joined: 24 Jul 2008
Posts: 10
Posted: 2008-08-03 10:09
Back to top
Reply with quote
|
I want to help the attendance officer of my club collect and analyse attendance statistics of members.
tbl_members holds members' details.
tbl_calendar holds details of club meetings.
I propose a new table (tbl_attendance), which will have the following fields:
attendance_key (unique key for this table)
meeting_key (refers to the meeting in the calendar)
member_key (the member whose attendance is being logged)
attendance (an enumeration, 'absent', 'present', 'credit', 'unknown')
It's simple enough to generate a PME script to edit tbl_attendance, with pull-downs to select the member and the meeting date, and radio-buttons for the attendance details, but this will be very laborious when it comes to editing the attendances for a particular meeting.
What is required is a column of names of members eligible to be at a particular meeting (already joined and not yet left at that date) and a column of radio-buttons to indicate each member's attendance. "Credit" for attendance may be earned for a missed meeting by various means, and may have to be put in at a later date.
I'd appreciate a steer from the group on how to approach this problem.
Many thanks!
|
Post new topic
Reply to topic
|
|
|
|