Originally Posted by paulinetaylor85
You will insert a new table via using SQL code add your column follow it. I have given the example. Insert into Stu_Table values(1,'name');
Um, what? Are you referring to the use of an auto increment pk? That will have no practical purpose on this issue; the OP is incrementing a different field in the db, not the primary key (which cannot be incremented as shown in the op as that would eventually cause conflict on other pk).