I see how to setup an autoincrement field.
I am migrating a database that has membership numbers already assigned. The previous system incremented them by 7, of all things, and I'm being asked to maintain that system.
Avoiding all the political or design ramifications, my simple question: can I get the system to increment the number by 7 each time a new User is created, and if so, how?
Alan Frayer
Don't just read the news - make the news!
Your World News - http://yourworldnews.frayernet.com
I am migrating a database that has membership numbers already assigned. The previous system incremented them by 7, of all things, and I'm being asked to maintain that system.
Avoiding all the political or design ramifications, my simple question: can I get the system to increment the number by 7 each time a new User is created, and if so, how?
Alan Frayer
Don't just read the news - make the news!
Your World News - http://yourworldnews.frayernet.com