I'm workin on an application that is supposed to be generating certificates.
Here are the steps:
1- input certificate data
2- generate certificate number
3- create the certificate and save its data in the database
i have a table in the database which will hold certificates. The database number should be Symbol-Number-Year (ex. TS105-2014) the symbol is static but, i want the number to be auto generated in a sequnce and the year to be incrumented also.
Thanks in advance