Adding an incremented field

[bombplayer]

I am in the process of writing an insert routine to a history file from a daily file. This history file has an id field which is used to link to other files. How can I increment additions to the history file so that each has a distinct id number (i.e. last record in history file is 10, first record added is 11, second is 12 and so on)?

 

[Terpsfan]

Are you talking about a file or a table? If you want to add an identity field, go into the design view of the table. Place a check on the Identity column for that field and make sure that the Identity seed is the number you want to start with and the increment is set to 1.

 

[bombplayer]

Sorry it is from a table to a table. The identity is set to one. Tried it out worked like a charm. Think I tried to overthink that one

 

[SQLSister]

Look up identity property in Book online