I am trying to create a database at work that stores the details of students and checks that are carried out each week for each student.
So 500 students have 3 checks per week every week for 39 weeks.
I want to be able to fill this in on a fresh datasheet each week for a whole class of 33 students but to store the data collected from previous weeks.
My initial though was to have TBL_student linking to TBL_week then to TBL_check but this doesn't work!!