Reviewing and changing relationship traversal

Use the Traversal Steps window to review the traversal of tables and relationships in the selection of data. You can also change the order of tables for the selection process.

The process can repeat steps any number of times according to relationships you select and criteria you specify. When a relationship is traversed to select parent rows for child rows that are already selected, any selection criteria for the parent table are ignored.

Any table can be revisited several times in successive steps. Cycles can 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.

  1. Expand the folder in the Directory Explorer that contains the access definition, expand the Access Definitions node, and double-click the access definition. The Access Definition Editor opens.
  2. Select the Relationships tab.
  3. Click Show Steps. The Traversal Steps window opens.
  4. To change the order of a table in the selection process, complete the following steps:
    1. Select the table in the Set table order list.
    2. Click Move Up or Move Down.
    3. Click OK. The Traversal Steps window closes.
    4. Save the access definition.


Feedback