I have a form that collects info about new class sessions - name of class, start date of class, teacher of class, etc.

I can generate a "session code" from the collected data (initials of class, start date, etc), but don't know how to get that into the database. I'd LOVE to be able to generate it from the info collected in the form before everything's deposited into the database with the click of the submit button, but figured I'd instead have to have an "unseen" page, pure ASP, that takes care of this instead? Tried that, got it to find the last database entry of all the class info, and generate the new code, but I don't know how to get that back into the database. I really don't want to have to hit another submit button just to put in this little bit of data.

Suggestions?
Thanks!
Jeph



Edited by - jephers on 07 Apr 2002 05:10:45