Relationship table view displays related data in master-detail style. You can switch to the perspective using the toolbar button or “Window” menu.
Double-click any table, view or synonym node in the “Database Explorer” to popup the “Create Selection Query” wizard, which allows users to create a selection query against the database object, and execute the query. The query result will be displayed in the top grid as master table data.
All data in the related tables are displayed in the bottom grids as detail table data. As shown in above screen shot, the data in PurchaseOrder table are displayed in master view. All its related data, such as LineItem, OrderTaxInfo, Customer, and Shipment records are displayed in the detail grids. Navigating to a master-table record, the corresponding detail-table data will be refreshed accordingly.
The master-detail style is a popular way to display the data relationship. It’s also very convenient to render data with only one level of relationship.