C
CK
OK, i'm going to try to describe what I'm doing as best I can. I have a table
called tblCourseReg with the fields lngRegNo, lngCourseNo and lngStudentNo. I
have another table to store the scores and grades called tblGrades. The
fields in tblGrades are lngGradeNo, lngRegNo, strAssessmentType, bytScore.
Based on the lngCourseNo, I want to insert all the lngRegNo into the
tblGrades table. In addition, I want to enable a user to enter the assessment
type in a dialog box or field and then insert that at the same time.
The lngCourseNo may be repeated many times because for the same course and
students, there are many assessment types like project, book reading, exam,
etc.
The problem is that when I used an update query, it will update all repeated
courses with the new assessment type i just entered. How do I prevent the
update query from updating all records but only the currently inserted ones?
Hope this is not too confusing. Thanks.
ck
called tblCourseReg with the fields lngRegNo, lngCourseNo and lngStudentNo. I
have another table to store the scores and grades called tblGrades. The
fields in tblGrades are lngGradeNo, lngRegNo, strAssessmentType, bytScore.
Based on the lngCourseNo, I want to insert all the lngRegNo into the
tblGrades table. In addition, I want to enable a user to enter the assessment
type in a dialog box or field and then insert that at the same time.
The lngCourseNo may be repeated many times because for the same course and
students, there are many assessment types like project, book reading, exam,
etc.
The problem is that when I used an update query, it will update all repeated
courses with the new assessment type i just entered. How do I prevent the
update query from updating all records but only the currently inserted ones?
Hope this is not too confusing. Thanks.
ck