im doin a2 ict and the coursework is an ict assessment system, students take certain amount of tests, their info is split into 2 different tables:
tblStudent: (PupilID, FirstName, SecondName, TMG, Year, Form, SetRef)
tblAchievement: (PupilRef, TestID, Grade)
in student table is their tmg i...