Jean MAURICE wrote on 2013-04-22: > Le 22/04/2013 17:54, Gary Jeurink a écrit : > I made an intermediate table spots (classID, studentID, > clientID) > my two cents : just add a date field 'day' in this table and insert one line per > student per classe and per day. You'll be able to count the number of days in > each class for each student, to know where a student is ... > > in other word, in this table, you have the smallest grain (piece ?) of information. > > HTH > The Foxil
Another option is the spots table also gets a unique key, spotsID. Then then an Attendance table will hold the spotsID, date, and attendance status. It looks like the attendance table will be a many to 1 relationship to the spots table. The date may end up being a key to a class schedule table. Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
