Hello all,
I'm new to Access and databases, so apologies if my question is in the wrong forum. In that case, mods please move it to the correct one.
I'm attempting to build a database with some reports and forms to manage membership data for a club and to track attendance at their monthly meetings. I have several tables so far, but the gist of the problem I'm having right now can be captured by three tables. Here are these tables and their relationships:
Essentially, tblActMemAtt is a junction table between tblMember and tblMeeting. I want to use that table to record attendance at meetings by members after the meeting, and to record cancellations, which occur -- and are recorded -- before the meeting. I've defined a composite index consisting of amaMemberID and amaMeetingID for which I don't allow duplicates.
I've managed to enter attendance data for a month in tblActMemAtt by using the datasheet view, but it was painful, time-consuming, and error prone. (There are around 150 members in this club.) I'm building the system for someone who's not computer savvy and I need to find a simpler way to enter attendance data.
If possible, I'd like to build a form where the user would pick a meeting date from a list, and the form would display all member names from tblMember together with the "Present" column from tblActMemAtt for each member. The user would then scroll through the list of names and place a check in the amaPresent column for each member who attended the meeting. After all the check marks have been placed (or while they are being placed), I envision records being inserted into or updated in tblActMemAtt. Note that their could already be records in tblActMemAtt because a "cancel" may have already been recorded for that member and meeting. (Sometimes members cancel and attend anyway.)
I've looked all over for an elegant way to handle this, but I haven't found anything, so I thought I'd drop by here and seek the advice of those more experienced than I. Any help or ideas would be appreciated.
Thanks in advance.