next available number
Hello
This is like a regular form that when the user enters this page, they fill out the info and hits the submit button.
However this is a variation. When the user opens this form, it will pick up the next available "special" number. This "special" number is in the same table as the above information and it will already been populated and existing.
This number that will be picked will be the lowest number without any data associated with it yet.
So everytime a user enters this form, the lowest number without data gets picked and the user inputs the info. How can this be done?
Thanks.