Define Relationships

On the Relationships tab, review the relationships and the traversal path to be used in the Extract Process. The extracted set of data must be referentially intact; therefore, for this set of data, the Extract Process begins with the rows specified from the ITEMS table and proceeds to the related children from the DETAILS table.

To ensure that the relationships between DETAILS and ORDERS and between ORDERS and CUSTOMERS are traversed from child to parent, select Option (1) for these relationships. (This is the default.)

In order to retrieve the additional DETAILS rows for the ORDERS rows and extract complete order information, select Option (2) for the relationship ROD between ORDERS and DETAILS. This option will ensure that the Extract Process retrieves all rows from the child table (DETAILS) related to the parent table (ORDERS).

Options 1 and 2 selected on Access Definition Editor

For this scenario, do the following in the Relationships tab: