Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Increment field!

Status
Not open for further replies.
nowayout

nowayout

Programmer
Feb 25, 2003
364
US
Hi all,

How can i change the field to make it increment automatically. such as ID field to auto increment for each entry.

Thanks
 
Sort by date Sort by votes
there is no choice in EM when creating new table!!
 
Upvote 0 Downvote
There is an Ident data type. You can look it up in books online and read how it works.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
320
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Adding field duplicates records
Replies
16
Views
266
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
173
grnzbra
grnzbra
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
214
Chris Miller
Chris Miller
JD5241
  • Locked
  • Question
SQL Field - check for specific count of characters 1
Replies
2
Views
131
JD5241
JD5241

Part and Inventory Search

Sponsor

Back
Top