Hello very smart people.....<br><br>We the mono-neurons salute you.<br><br>I'm creating a database to track attendance to monthly group meetings. <br><br>So I created a table with only the user name and the group and a separated table with the names of the groups so you can add groups to them.<br><br>There are some issues:<br><br>some users are in two or three groups<br>the users may change groups from month to month but I still need to keep the history which means that regardless of change they have to show as members of the group for that specific month. I figure I can use the basic table I have to generate monthly attendance tables (which I will render permanent) with a macro or some VB Code (I'm still a little potato) I may have to report attendance by group and by person and by month.<br><br>Before I start reinventing the wheel... any ideas as to how to tackle this task in a simple form... any resources to help me on my task....?<br><br>anybody has done something similar to offer advice....?<br><br>thank you...... <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......!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Attendance Database 1
- Thread starter Dumboy
- Start date
you need 3 tables<br>1 for People<br>1 for the Groups<br>1 for the people that are in groups<br><br>Table1<br>PeopleID Name Address CurrentGroup etc<br>1234 Frank Jones 1256 86Th Ave N. 1111<br>2345 Sally Smith 5454 102nd Street 3333<br>9876 Harry Farter 500 12th Street 1111<br><br>Table2<br>GroupID Group Name<br>1111 Good Group<br>2222 Another Group<br>3333 Third Group<br><br>Table3<br>PeopleID GroupID<br>1234 1111<br>1234 2222<br>2345 3333<br>2345 2222<br>9876 1111<br>9876 3333<br><br>So you can 1 to many People<br>1 to many Groups<br>and 1 to many People in 1 to many Groups<br>So you add a new record for each person for aech group they are in.<br>If they are currently in a group then have a field in the People Table called CurrentGroup and put the number in there.<br>But you are still keeping a History in Table3<br><br>OK<br>
Dumboy, I answered your other question on this topic before I saw this question. If you also need to keep track of who was a member of a group on any certain date (not mentioned in other post), it might be best to add date fields (start and end) to tblMembership.
-
1
- Thread starter
- #4
DougP.... Elizabeth.....<br><br>A big hugh and thanks... that puts me on the right track (I was thinking on using only two tables, one for the groups and keeping one with the most current configuration to make changes and create the latest attendance table ... but I guess if I do it your way instead of having lots of monthly tables I could have just fields associated with the session for the meeting on a history table. So my next challenge is to find a way to add afield to the table to create a new meeting session. <br><br>I'll let you know how is going.... thanks again.... <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......!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
