Hi,
I've a query "qryTS_Assigned_PIP1" below to report the tutor-student map. I notice that tblTAssign_PIP is fine for the assignments but I encounter a problem of duplication of the teacher-student assignment with the following query.
SELECT tblTAssign_PIP.TRef, tblStudent.SUID, tblStudent.SName, tblTutor.Title, tblTutor.LastName, tblTutor.OffTel_1, tblTutor.FirstName, tblTutor.OffFax_1, tblTeachTT_PIP.DtTeach, tblTeachTT_PIP.APM, tblTeachTT_PIP.Day, tblTutor.ClinicAdd1, tblTutor.ClinicAdd2, tblTutor.ClinicAdd3, tblStudent.Gp, tblTeachTT_PIP.SSubGp
FROM tblTeachTT_PIP INNER JOIN ((tblTutor INNER JOIN tblTAssign_PIP ON tblTutor.TRef = tblTAssign_PIP.TRef) INNER JOIN tblStudent ON tblTAssign_PIP.SUID = tblStudent.SUID) ON tblTeachTT_PIP.ID = tblTAssign_PIP.TTID;
tblTAssign_PIP contains the assignment of tutor(TRef) to the student(SUID), TimeSession (TTID) in which teacher and student meet.
tblTutor contains primary key "TRef" and tutor's information, ...
tblStudent contains student's "SUID" (=Student UID), "SName" (=Student Name),...
tblTeachTT_PIP contains timetable in which "ID" is the key of the timeslot teacher and student meet.
Pls. refer to the screenshot for the duplication record with the above query.
I'm appreciated for any suggestions.
I've a query "qryTS_Assigned_PIP1" below to report the tutor-student map. I notice that tblTAssign_PIP is fine for the assignments but I encounter a problem of duplication of the teacher-student assignment with the following query.
SELECT tblTAssign_PIP.TRef, tblStudent.SUID, tblStudent.SName, tblTutor.Title, tblTutor.LastName, tblTutor.OffTel_1, tblTutor.FirstName, tblTutor.OffFax_1, tblTeachTT_PIP.DtTeach, tblTeachTT_PIP.APM, tblTeachTT_PIP.Day, tblTutor.ClinicAdd1, tblTutor.ClinicAdd2, tblTutor.ClinicAdd3, tblStudent.Gp, tblTeachTT_PIP.SSubGp
FROM tblTeachTT_PIP INNER JOIN ((tblTutor INNER JOIN tblTAssign_PIP ON tblTutor.TRef = tblTAssign_PIP.TRef) INNER JOIN tblStudent ON tblTAssign_PIP.SUID = tblStudent.SUID) ON tblTeachTT_PIP.ID = tblTAssign_PIP.TTID;
tblTAssign_PIP contains the assignment of tutor(TRef) to the student(SUID), TimeSession (TTID) in which teacher and student meet.
tblTutor contains primary key "TRef" and tutor's information, ...
tblStudent contains student's "SUID" (=Student UID), "SName" (=Student Name),...
tblTeachTT_PIP contains timetable in which "ID" is the key of the timeslot teacher and student meet.
Pls. refer to the screenshot for the duplication record with the above query.
I'm appreciated for any suggestions.