I'm looking to create an Access DB for posting attendance for students. How can I set up a form to show the following: one 'Date' (top of page), list of all 'Students' from a table, and an attendance 'Result' per student, e.g. absent, present. I'd like to have the the 'Result' field cleared (and saved) whenever the user changes the 'Date' at the top of the page.
How can I achieve this? Should I create 3 tables? DATE, STUDENTS, and RESULT. If so, what type of relationship?
Thank you.
How can I achieve this? Should I create 3 tables? DATE, STUDENTS, and RESULT. If so, what type of relationship?
Thank you.