View Related Data

When you browse data within a table, you can use the Join facility to join to tables related to the displayed data. This feature is useful for reviewing related data. You can join to one, several, or all directly related tables in one join operation.

Join

In the grid, right-click the row highlighted when you clicked Find Next. Click Join from the shortcut menu to display the Select Join Table dialog.

Select Join Table dialog

One table is related to CUSTOMERS: ORDERS is the child of CUSTOMERS. Join to ORDERS by double-clicking the table name.

Related data is displayed in an additional browse window.

Browse Archive File Table Data dialog

Join Arrow

You can see that Pick-a-Flick has several archived orders in the Archive File, but you must join to the archived DETAILS rows to determine if any of the four include Item DC002. In the ORDERS browse window, click the Join Arrow button Join Arrow button to open the Select Join Tables dialog and double-click DETAILS to display the Select Join Table dialog.

Select Join Table dialog

The names of tables directly related to ORDERS are displayed: CUSTOMERS is the parent of ORDERS, and DETAILS is the child of ORDERS. Join to DETAILS by double-clicking the table name. Related data is displayed in an additional browse window.

Browse Archive File Table Data dialog

Current Row Indicator

In the Current Row Indicator column, click the cell next to an ORDERS row to display the related DETAILS rows. To move to a different row, scroll the ORDERS window and click the Right Arrow grid cell Right Arrow grid cell for the desired row. Notice that when the current row indicator is on the row for ORDER_ID 375, the DETAILS window shows that 12 copies of Item DC002 were included in the order. By scrolling the ORDERS window to the right, you can record the date the order was posted and the date it was shipped, in order to provide this information to the customer, Pick‑a-Flick.

When finished, return to the Archive Directory Maintenance dialog by closing the Browse Archive File Table Data and Browse Archive File dialogs.

Note: See the Common Elements Manual for additional information about the Browse Utility.