I currently have database which is used to have list of programs and persons (and to which program they joined). Now i would also like to have attendance list.
For example:
When i add new program i would also write here how many meetings this program will have.. and than when i open form there would be for example 5 checkboxes (if i would wrote number 5 under meetings when adding new program). Than i would just check if person was present on this meeting.
In table Person i have:
PersonID
Other info..
In table Program i have:
ProgramID
ProgramName
StartDate
EndDate
Both are connected in table PersonProgram:
ID
PersonID
ProgramID
JoinDate
Is this possible to do, checkboxes would work or not?
Thanks