Question:
I need to create a page that will issue a unique authorization number after a customer has filled out a form. I have created a form that writes to a database and then displays a confirmation page. Can I get the confirmation page to generate an authorization number using JavaScript or ASP? Customers will then be able to get repair authorization numbers online before they send in equipment for repair.
Answer:
You can use an ‘Autonumber’ or ‘Identity’ field in your database table as your confirmation number. Then when you insert the data in the database, access this ID value and return it back to the user as his/her confirmation number.