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.