https://www.webmaster-forums.net/crss/node/1039148 en https://www.webmaster-forums.net/web-database-development/autonumber-mssql#comment-1222314 <p>It turned out that there was another table in the database that held the next number for the customer table. So I have to select it, then run my insert query using the number I pulled from the other table, and then do an update and add one to the number in the other table. Confusing!</p> Sat, 28 Jul 2007 15:17:08 +0000 teammatt3 comment 1222314 at https://www.webmaster-forums.net