Select Show Steps from the Tools menu to analyze the traversal path to be used in the process. Use Show Steps to evaluate the tables and relationships and display the steps performed to select the data. This evaluation can ensure that you retrieve the desired set of data.
Assume that you want to select data from three tables: CUSTOMERS, ORDERS, and DETAILS. The CUSTOMERS table is the Start Table and rows are selected using Point and Shoot.
The ORDERS table is a child of CUSTOMERS, and DETAILS is a child of the ORDERS. The steps in the process are:
The steps in a process may be repeated any number of times according to relationships you select and criteria you specify.
In a single step, rows may be selected from more than one table, or to satisfy more than one relationship. For example, if the DETAILS table is related to both the CUSTOMERS table and the ORDERS table, Step 3 is similar to the following:
Any table may be revisited several times in successive steps. Cycles may also be involved. A cycle causes a set of tables to be traversed repeatedly until a complete pass through the cycle does not result in selecting additional rows.