User Guide

Chapter 172
To filter the customers recordset with the customerID:
1
Shift select the following elements:
 Customers recordset (in Basement)
 CustOrderDetails recordset (in Basement)
2 Right click and choose Possible Interactions. Scroll to the Database Filter
category and double-click the interaction:
Filter Customers with related field from CustOrderDetails
3 Set the parameters according to the following table, then click OK.
Now, you need to repeat the same process with the OrderTotals recordset so that is
likewise filtered to the appropriate data for a captured order. In this case, the
captured order is filtered on the orderID.
To filter the customers recordset with the orderID:
1
Shift select the following elements:
 OrdersTotals recordset (in Basement)
 CustOrderDetails recordset (in Basement)
2 Right click and choose Possible Interactions. Scroll to the Database Filter
category and double-click the interaction:
Filter OrdersTables with related field from CustOrderDetails
3 Set the parameters according to the following table, then click OK.
Parameter Description Set to:
Filter column Defines the columns with which
to filter a recordset.
CustomerID
Filter By Defines the columns with which
to filter a recordset
CustomerID
Parameter Description Set to:
Filter column Defines the columns with which
to filter a recordset.
OrderID
Filter By Defines the columns with which
to filter a recordset
OrderID