I am current upgrading some of the functions on an inventory system.
Current system accepts manual data input from the user and stores them in a SQL database.
One of the inputs is control number which is a primary key in one of our table so it needs to be unique. Since it is manually entered into the system, we have to keep track of all of control numbers so there is no redundant control number which is difficult since we have hundreds of items with unique control number that are entered into the system everyday.
Yes, it is waste of time.
So I want our newly upgraded system to have a function where the control number is automatically generated so the control numbers are controled by the system. I know there something similar in MS Access 2007 but I cant seem to find it on Visual Studio.
Format (2 Characters followed by 8 numeric numbers)
Example: AA12345678, AA12345679, AA12345680
I would appreciate if anyone can tell me how to go about it, better if i can see some codes.