Useful to set one of the columns as the primary key.  To make the primary key an auto generated number create the column as type 'int' then in its properties :

Identity Specification = Yes
Identity Increment = 1
Identity Seed = 1

 

 

Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published.