Maybe this might help
Larsentime...
You are probably new to dreamweaver. Here is what happens and what you need to know about getting the data. You are a little confused by a few things.
First, let's start with an order. You will have the customers name, address, ship to address, etc... The proper name for this is call the "Master Record"
Secondly, you have the order record that will contain such things at order id, order date, total amount of order, shipping method, etc... This record would be consider also a "Master Record" because this record will have potentially many sub records for each item ordered. (ie...I place an order on Amazon for 3 books)
Amazon has my customer (Master) record and then it has my order (Master) record for the order I just placed and then it will have the details of each item on the order in another table.
So that is kind of a simplistic view of how an order is put together from a database standpoint.
Now, in order to reference all this information and have access to every piece of the data (Customer, Order, Order Detail) you have to build (if not already done) a recordset that queries the tables and pulls into the page all the data.
When you do this query all the system (php, asp, or whatever) is doing is going out to read the tables, saving the results in an array of variables and now you can do whatever you want with those variables and arrays.
Dreamweaver and Webasssit make is exceedingly easy to output to the page the data that was queried/read/retrieved from the database and display it on a page using html.
So, let's say you want to email your supplier what basically sounds like a duplicate of the order you just received from your customer.
If you are on the order detail page, you already have the customer's information (name, ship to address, and the products of the order.
I"m not sure why Eric was saying you needed to build a recordset to get the customer data, it's already there which means that there has already been a query of the database and all the data you are looking is available to you in an array for you to use.
Anyhow, you could build a simple form that has all the fields for the order and use Universal Email (one awesome product) and send the email to supplier.
Or...another option is to simply add your supplier to the email that gets send from either paypal or paypal pro. You may not want to do this if it has information you don't want to share with your supplier.
I hope this helps and doesn't confuse you more. Please know that once you understand how this all works and is put together, you'll realize just how simple they have made it to get the job done.
If you haven't solved this in the next couple of weeks, let me know as I'm about to implement this for a client and I can share what I did.
Terry
