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
_______________________________________________
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.
