I can't seem to pin down where the problem lies, probably because I'm very inexperienced in Access. But it has to do with some sort of duplication of student data.
Intro: This is a school database to record student info, grades, enrolments (semesters, scores), and attendance.
Here's the reproduction:
This is a form showing a record of one student - DOEK CHHORVIN.
There are a couple of sub-forms each with only ONE record.
As you can see, there are 1095 records of students in total.
(Capture.jpg)
The multiple problems start when I decide to create a new enrolment record(because of a new semester) to the student through the "Enrolment Page" sub-form.
The number of total student records increases once I refresh the form. It is as though I added a new student entirely.
(Capture4.jpg)
It is an intended function that once a new Enrolment is made, NEW(meaning all data is 0 or null) Grading and Absence records are added as well.
But because of the duplication of the student record itself. Each subform is also duplicated.
(The two "Enrolment Page" records are different as per New Record,
but both the "Grading Page" and "Absence Page" duplicated records take on data from previous records.)
So now, looking at the "StudentDetails" form, there are 2 same students. Each of them have 2 same "Enrolment Page", "Grading Page" and "Absence Page"
(Capture9.jpg)
This is the Student table where all the actual data is stored:
(Capture15.jpg)
So obviously, no duplication of Student records.
But, as intended, there are extra records in the Enrolment table.
This is the list of records populated by query ran by clicking the "Search" button you see on the top right of every "StudentDetails" form:
You can clearly see the duplication here. So it shows that while the actual data in the Students table is not duplicated, creating a new record in the "Enrolment" page causes another record to appear in the query, making it seem in the form, like there are duplicate students.
I'm seriously lost.
Here is the accdb file if you would like extra testing(https://www.dropbox.com/s/1bc9cl6ji6...Ori.accdb?dl=0).
I appreciate all the help I can get!
Thanks in advance!