OK - I have bitten off more than I can chew, and I hoping for some very specific help here. I have designed simple .asp pages before that just dump into Access databases. Now though, things are getting more complicated and I don't know where to even start. The scenario is: I need to create something where students can sign up for a class, then when they submit their form the email client (Lotus Notes 5.0) is opened with a unique link that point back to the record that they just entered (there is an autonumber field in Access as the primary key, but that can be changed if necessary). They will then select their manager's email from the Lotus Address book and send it off. Their manager will receive the email, click on the link, the database results for that particular entry will display, then the manager will update the record by clicking on an approval button. The .asp page is called TrainingSignUp.asp, the database is TrainingSignUp.mdb, the Primary Key is ID (autonumber in Access DB).
I have generated the appropriate forms and the database, but I don't know what to do On Submit in order to get it to retrieve the unique ID of the record that was just submitted in order to create the specific hyperlink to be emailed to the supervisor. I also don't know how to get it to just open Lotus Notes instead of automatically sending the email (they won't know their supervisor's email off hand).
I recognize that this is a loaded question, and that it is waaaaay beyond my skills, but I am hoping an expert will take pity on me and show me what to do!!