I want to simulate a spreadsheet having names, dates, and a way to do a checkbox under each date. I’ve tried one of everything and not happy with any of it. The dates are in a table and the names are in another. The final result would put both in a table of its own. Any ideas?
Dates table with dateid as autogenerated KeyID. Students table with student ID field as unique Key.
Attendance table with: StudentID,DateID,Attendance (tinyint, default to 0)
Attendance is either 1 or 0
Then make a grid with the students table.
Add 31 columns with labels at the top.
Fill the header columns with Dates according to the month that was selected.
On the Row event show a green check or red X depending the studentID, Dateid using a lookup function.
Let me play with this. Thanks.
m