I am using asp and dreamweaver 8, when I add a record to the database I would like it to automatically add the next largest number as the userID in my table…I have set it up so that a the other records are created, but the user id is a primary key field and I do not know how to make it add the next highest value (which will therefore avoid duplicates)
Can anybody offer any help?
