User Guide

Quick Store Tutorial 65
Inserting CustomerID into the Orders Recordset
The CustomerID is derived from the Customers recordset, and inserted into the
Orders recordset.
Bind the CustomerIDHidden element to the Customers recordset:
1
Right-click the CustomerIDHidden element, in the Basement, and select
Attributes.
2 From the drop down list for Content, select Recordset.
3 Select the Customers recordset, and the CustomerID column.
4 Leave the check boxes unchecked.
Now, apply the interaction to insert the customer ID into the recordset when the
SubmitOrder button is clicked.
5 Shift-select the following elements:
 SubmitOrder button (on page)
 CustomerIDHidden (in Basement)
 Orders recordset (in Basement)
6 Right click and choose Possible Interactions. In the Database edit category,
double click the interaction::
Use CustomerIDHidden data to update/insert in Orders when SubmitOrder
is clicked
7 Set the Recordset Column parameter according to the following table, then
click OK.
This next Interaction inserts a new order record and allows you to obtain an
Autonumber OrderID from the Orders recordset when the new order is
generated. The Autonumber OrderID is placed in a session element, which will be
used extensively as you will see later.
Parameter Set to:
Recordset Column CustomerID