if you are using Enterprise manager to create you fields, select the field you need to be autonumber (which must be of any of the numeric type) and in the properties of the field (just below), set the Identity property to True.
if you create your table by SQL statement, add the word IDENTITY (create table Test(id int IDENTITY, lname varchar(50), ...)
>I didnot find autonumber field type .. is it possible for me to get this field type in Ms. SQL Server? I need advice .. thanks a lot in advance
>
>Regards
>Winanjaya
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com