How to copy fields from one table to another table

R

Rodney

I have two tables with sum of the same fields required in both tables.
One table called StudentCourses and the other ExamResults.
When we add a student to the StudentCourses table we would like to
automatically add selected fields from StudentCourses to ExamResults.
I have tried an update query and just cannot get it to work.

I would appreciate some adivce
Rodney
 
Top