Kill_Switch
Go Easy I'm New
- Local time
- Today, 09:58
- Joined
- Apr 23, 2009
- Messages
- 58
Good evening.
I'm creating a database in which when a new process verification is generated it is given a new record number. (2010-001, 2010-002, etc).
My question is, I would like this number to be automatically generated once the user wishes to create a new "process verification". How would I go about doing this? This number will be the PRI KEY as there will be no duplicate records of these audits/verification.
yyyy-\[next seq number] ?
Any help would be great.
I'm creating a database in which when a new process verification is generated it is given a new record number. (2010-001, 2010-002, etc).
My question is, I would like this number to be automatically generated once the user wishes to create a new "process verification". How would I go about doing this? This number will be the PRI KEY as there will be no duplicate records of these audits/verification.
yyyy-\[next seq number] ?
Any help would be great.