Okay - I'm a little confused about something here. I will obviously need the Shipping address to send to the supplier (its a drop ship supplier). Is that something I need to add to the page or is it already there?
So once that question gets answered - let's assume it doesn't have it. I don't know how to add it to the page then. If it's already there, then great, but otherwise, I'll need more direction.
So once I have that figured out... I'll have to create a form where all it does is submit the email - all I have to do is make sure the name or id is different then the main form that's already on that page, correct? (the update order page). And then what, I load up universal email, tell it all the stuff I want in the email and to send it on submit of that form, and to filter based on the orderID, and I'm good to go?
Just FYI if you did want to put in any info that is only in the users table it would be a standard Dreamweaver recordset that you would use. You would just need to make sure that you fill out the section for the filter part so that it is filtered for the user that placed the order. You would select the userID column to filter by, then specify an entered value and use the recordset value for the userID from the orders recordset. This new recordset would hold the details of the user that made the order. You could then make use of the values for that user the same as you do for the order by using the bindings that are available.
Please post back if you have any further questions or need any more specific information about any part of this I would be glad to help you.