Attendance list ...? Elizaaabeeeethhh...! 1

[Dumboy]

Easy...?<br><br>Elizaaaabeeeeethhhhhh...........!<br><br>I need to create a application (thinking excel) that measures attendance on a list of people divided in groups for monthly meetings.<br><br>some users are in two or three groups.<br><br>they want me to have a single list of users with the groups they belong. This master list will feed, create the lists, and track attendance to the meetings based on the group value(s) associated with the person.<br><br>argggghhhh.........!<br><br>help! <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!

 

[elizabeth]

Dumboy, I don't know that much about Excel, and you did post in the Access forum, so here's an Access suggestion on structure.<br><br>tblMembers: MemberID, other descriptive fields.<br>tblGroup: GroupID, other descriptive fields<br>tblMembership: MemberID, GroupID<br>tblMeeting: MeetingID, GroupID<br>tblAttendance: MeetingID, MemberID<br><br>If each group always meet at the same time of month, time of day and place you might want to make that descriptive info in tblGroup. Otherwise if it varies it would belong in tblMeeting, and you could store the usual or default place & time in tblGroup so that you can have it show up as the default when you go to fill in tblMeeting.<br><br>tblMember 1:n tblMembership<br>tblGroup 1:n tblMembership<br>tblMember 1:n tblAttendance<br>tblGroup 1:n tlMeeting<br>tblMeeting 1:n tblAttendance<br><br>When you build forms, you can use a query on tblMembership for comboboxes to limit who you can select as attending any given meeting's Attendance, etc.<br><br>This is just off the top of my head so just holler if you run into any inconsistancies...HTH