Good day team,
I'm a teacher not an IT person, but i like to do my work using MS Access
my simple work is as follows:
1- I'm teaching multiple grades for example ( Gr10, Gr11, Gr12)
2- I'm teaching multiple subjects for example (Math, Physics, Chemistry)
3- student can be assigned to only one grade, but can attend sessions for multiple subjects, for example Div in Gr11 but can attend Math and English sessions
4- the attendance sheet should contain the fields, (Session_Date, Grade, Subject, Student_Name)
these four fields need to be entered through a Data Entry Form.
till here it seems fine to me, but i have the challenge which is:
in this form, when i select the Grade, and subject, i need to see only the list of students who were registered for this grade and subject.
I believe i missed the correct tables structures and its relationship, and i couldn't understand how to build this and if i need this auto number primary key in any of my tables? please advise
the same was posted at the below link:
https://www.codeproject.com/Questions/5283703/Creating-a-student-attendance-sheet-in-MS-access