ITempleman
Registered User.
- Local time
- Today, 12:15
- Joined
- May 2, 2016
- Messages
- 13
I created my form with two sub forms (so far) the top form has the:
studentID. firstname, lastname, acadplan, acadlevel.
On one of the sub forms I have the date they came into the office, counsellor, reasons and notes. The second form will record the courses each student signs up for, the year and eventually the grade.
Now my problem is, that when I enter the data for the students, it should record one form and then multiple entries in the sub form. Well it is doing the latter but also duplicating the main form - so I have one student who comes twice to see a counsellor, it shows twice in the main form and then both appoints show in the sub form for both of the main forms. I have 519 main forms when in reality I should only have about 430-450.
I was really proud of myself for getting this far and thought I had cracked it.
Can anyone tell me if I should have been done something in the original table for the appointments ie - no duplicates for 'student number', but allow duplicates in the subform table.
Any help appreciated with grateful thanks.
studentID. firstname, lastname, acadplan, acadlevel.
On one of the sub forms I have the date they came into the office, counsellor, reasons and notes. The second form will record the courses each student signs up for, the year and eventually the grade.
Now my problem is, that when I enter the data for the students, it should record one form and then multiple entries in the sub form. Well it is doing the latter but also duplicating the main form - so I have one student who comes twice to see a counsellor, it shows twice in the main form and then both appoints show in the sub form for both of the main forms. I have 519 main forms when in reality I should only have about 430-450.
I was really proud of myself for getting this far and thought I had cracked it.
Can anyone tell me if I should have been done something in the original table for the appointments ie - no duplicates for 'student number', but allow duplicates in the subform table.
Any help appreciated with grateful thanks.