Review the Access Definition

Consider the steps performed to extract the data based on the selection criteria, selected relationships, and specifications for Options (1) and (2). The following simplified data is displayed for each table to aid in the explanation.

Steps:
  1. The rows from the Start Table, ITEMS, are selected by Point and Shoot to extract specific items. The specific ITEMS in this example are CH1 and CH4.
  2. The DETAILS rows for these ITEMS rows are extracted because the DETAILS are children of the previously selected ITEMS using the relationship RID. The extracted DETAILS rows are DTL1, DTL5, and DTL8.
    ITEMS to DETAILS steps
  3. The ORDERS related to the extracted DETAILS rows, ORD1, ORD4 and ORD5, are extracted by traversing the relationship ROD from child to parent.
    DETAILS to ORDERS steps
  4. The CUSTOMERS related to the ORDERS are extracted by traversing the relationship RCO from child to parent.
    ORDERS to CUSTOMERS steps
  5. The additional DETAILS for the extracted ORDERS are extracted by traversing the relationship ROD from parent to child because Option (2) is selected. Additional DETAILS rows for ORDERS rows ORD4 and ORD5 are extracted.
    ORDERS to DETAILS steps
  6. The ITEMS rows related to the additional extracted DETAILS rows are extracted by traversing the relationship RID from child to parent. The rows for CH2 and CH3 are extracted from the ITEMS table for the additional DETAILS rows.
    DETAILS to ITEMS steps

Show Steps

Click Tools > Show Steps to display a narrative that describes the traversal path of the Extract Request.

Traversal path of the Extract Request shown on Show Steps

Click File > Close to return to the Access Definition Editor. Click File > Update and Return from the Access Definition Editor to update the Access Definition and return to the Extract Request Editor.