Hello,
I am now working on a db for generating a certain school certificate. I have this query based on students' table, and the necessary form. The problem is with generating certificate numbers.When I press the print button I want the system to assign serial numbers to the certificate automatically, if the first number is given. The next documents should be sequentially numbered, adding one at a time.How can we do this? Can it be done without a field in the students table for this newly generated numbers?
Any help is greatly appreciated.