eCart cart summary

I cant figure out the relationship between the database tables 'orders' and 'orderDetails'
However I want to record the first name, last name, email and ItemName in the database, orders table.
// WA eCart Store Cart Summary in Db in the confirm page.
$WA_table = "orders";
In the orders table I have created 4 new fields for 'first name', 'last name', 'email' and 'ItemName'.
I Have opened eCart Store Cart Summary in Db (orders Table) from the Server Behaviours panel
The new fields in the table now appear, I have dynamically linked them to the checkout form details in the ecart checkout form
"<?php echo ((isset($_POST["firstname"]))?$_POST["firstname"]:""); ?>"
And saved. All looks ok.
All the inserted items are available in the session.
Is this correct, Do I need to add any other information elsewhere?
Is there another way of doing this?
Thanks
David

first lets talk about the orders and order details relationship.

the orders table is where you store customer information.

the orderdetails table is where you store information about the products that where purchased as part of the order.

In the orders table, the primary key column orderID is used to create the relation to the orderdetails.DetailOrderID column


In the Store Oder Summary behavior, Make sure that the Order ID setting is set to the OrderID column, the "Store As" option is the name of a session variable that will contain the ID value of the record that is insert, make note of this.


In the Store Order Details behavior, Set the "Order ID" column to the detailsOrderID and bind that column to the session variable created by the Store Order Summary behavior.


In the store order summary behavior, bind the user columns like first name, last name to the checkout form elements.

In the Store Order details behavior, bind the product columns to the appropriate columns from the eCart object.

the store orders details behavior will create a record for each row in the cart display.

Thanks
That works great.
Last question for this topic. (I hope)

Previously I extracted information from a URL, namely a product ID
From your answer:

if(isset($_GET['job_id'])) $_SESSION['PBksID']=$_GET['job_id'];

this way the session will only get set if the job_id querysting variable exists.
....
once it is set, you should be able to use:
echo "Job identification=". $_SESSION['PBksID'];

How do I add the value/job_id number to a new field/column in my orders data base?
Thanks again
David

go to the bindings panel and click the plus button, select Session Variable, set the name for the new session binding to "PBksID"

Then in the store order summary behavior, bind the database column to the PBksID session variable.