Hi guys!
I have student and class databases, at the end of session students are transferred to next class, so an update is needed to change class to next class in student database from Class database
Student.ClassID is linked to Class.ClassID to show Class Name.
Now I want an update Query to update all records to next class.
I tried Class.ClassID+1, it displays the next class but how to update the same in student.classid.
Thanks in advance for any help.
Regards
Khan