Forum Discussion
Dates and links
I have 4 tables, a users attendance which contains there attendance for an idividual date, a users table, a groups table which organises users into group, the can move between thoose during the year ...
kentyler
Solution Sage
Solution SageYou might consider combing users / groups /user groups tables into one table that has one record for each day each user is in a specific group.
That would have the same "day" granularity as your attendance table and would make it easy to get the group attendance numbers for any given day.