Results 1 to 4 of 4
Jan 25, 2005, 12:46 #1
- Join Date
- Mar 2004
- Tulsa, OK
- 0 Post(s)
- 0 Thread(s)
autoincrementing a field other than ID
hi, I'm trying to find how I can autoincrement a field in addition to the ID field. Here's the layout.
ID (int, primary, unique, indexed, not null, autoincrement)
PROJ_NUM (int, not null, autoincrement)
PROJ_NAME (varchar, not null)
So i can show something like this:
0023 PROJECT ALPHA
0024 PROJECT BETA
Is there a way to do this and to also have the zeros show in the front? thanks.