All four processes ARE on the same page. I tried to put them in order. Updating the 2 tables first, then the insert script, then the email, which gets the last_id from the inserted recordset. Here's how the process works. The form is submitted on one page. It goes to a 2nd page, where it shows you what you have listed on the first page and asks you to confirm it. The third page of the process is actually where the udpating, inserting, and email takes place.
Should I eliminate the confirmation page and put all of the scripts on the page after the form is submitted? Or should I have the scripts run on the same page AFTER the submit button has been pressed?
I hope this makes sense to you.
Thanks.