Francisco H Tapia
my.lists at verizon.net
Wed Jun 16 10:43:52 CDT 2004
It's the Integer field and you set it to have seed value of (whatever value you want to start at) and an Identity increment of 1 (or whatever you see fit). Jeff Barrows wrote On 6/16/2004 5:55 AM: >What is the best way to create an auto numbering field for SQL? I am upsizing an Access 97 database to SQL and need to keep some fields as autonumbers. > >Jeff B > > -- -Francisco