I have a database with two tables called student,Repeaters with the following fields; StudentId,StudentGrade,schoolYear,RepetitionCode.The fields are similar for both tables.These tables will be tracking the student history hence a primary key is schoolYear. I created a form for entering infomation in tables in vb.net/asp,net. Everything is working fine. Now i need assistance(coding),that would help me to update the table student when we are in a new schoolYear,i.e if i enter a year in a textbox,a new record for the student should be created with studentgrade being increased by 1 if he is not a repeater.Any help is highly appreciated