Update query will not work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This database has a few tables some of which are:
tblCourseOccurence
tblDivision (this is the same as a class)
tblStudentCourses
tblCourseExams
tblExamResults
briefly I can have many Divisions on a course, many students to a division,
many exams to a division and inturn the student and many exam results to a
student.

What I am trying to do is when a student is enrolled to a division on a
course I want certain fields from the tblStudentCourses table to populate the
same fields in the tblExamResults table.
And then when we create an exam that is attached to a division I want
certain fields from the tblCourseExams table to populate the same fields in
the tblExamResults table. I have tried an update query but it just will not
play the game for me it’s probably something really stupid but I just can’t
see it.
The tables are structured as below (not all fields but the main ones):

tblDivision tblStudentCourses
tblCourseExams DivisionID AutoNO StudentCourseID AutoNO
CourseExamID AutoNO
CourseName DivisionID
DivisionID
DivisionName StudentPersonalNumber
ExamName

tblExamResults
CourseExamID (populated as exams are created)
ExamName (populated as exams are created)
DivisionID (populated as student is added to
division)
StudentCourseID (populated as student is added to division)
StudentPersonalNumber (populated as student is added to division)

I have tried to do this with a query but how the relationships are I can’t.
any help would be appreciated
Rodney
 
Rodney said:
This database has a few tables some of which are:
tblCourseOccurence
tblDivision (this is the same as a class)
tblStudentCourses
tblCourseExams
tblExamResults
briefly I can have many Divisions on a course, many students to a division,
many exams to a division and inturn the student and many exam results to a
student.

What I am trying to do is when a student is enrolled to a division on a
course I want certain fields from the tblStudentCourses table to populate the
same fields in the tblExamResults table.
And then when we create an exam that is attached to a division I want
certain fields from the tblCourseExams table to populate the same fields in
the tblExamResults table. I have tried an update query but it just will not
play the game for me it’s probably something really stupid but I just can’t
see it.
The tables are structured as below (not all fields but the main ones):

tblDivision tblStudentCourses tblCourseExams >DivisionID AutoNO StudentCourseID AutoNO CourseExamID AutoNO
CourseName DivisionID DivisionID >DivisionName StudentPersonalNumber
ExamName

tblExamResults
CourseExamID (populated as exams are created)
ExamName (populated as exams are created)
DivisionID (populated as student is added to division)
StudentCourseID (populated as student is added to division)
StudentPersonalNumber (populated as student is added to division)

I have tried to do this with a query but how the relationships are I can’t.
any help would be appreciated
Rodney
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update query will not work 2 2
Append query not working 2
combo list problems 5
Table Design 4
Fill In 1
Double relationship lookups 2
"all" in dropdown not working for query 2
Using Combobx In Continuous Form 4

Back
Top