Attendance list

[faca]

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

[ranman256]

stay away from the checkboxes, you only need the date.
if a person has the ProgramID and a Date , then they attended.
if the person is missing 5/26/2018 , then they did not attend that date.

I would have a tProgDates table that holds every program and every date for the program.
you can select the program, then a listbox would show all its dates.
select a Person, and dbl-click each date they attended, to run an append query to add it to tPersonProgram.

[faca]

stay away from the checkboxes, you only need the date.
if a person has the ProgramID and a Date , then they attended.
if the person is missing 5/26/2018 , then they did not attend that date.

I would have a tProgDates table that holds every program and every date for the program.
you can select the program, then a listbox would show all its dates.
select a Person, and dbl-click each date they attended, to run an append query to add it to tPersonProgram.

I've created table Attendance which has:
- AttendanceID
- ProgramID
- PersonID
- Date
- Hours

My form looks like this:

Attachment 34433

I only pick date once and than when i add new record date is automatically added from what i've choose but the problem is how to choose program?

For the date:
I choosed ProgramID and added this "Me.Date.Value = Me.TopDate.Value" in AfterUpdate

any suggestion how could i make that ill pick the date and program at the top and than only people from that Program will appear and i will only write how many hours they were present?

Thanks