Viewing Data in Related Tables

This topic gives a quick guide on how to view data in related tables with the help of Master-Detail Browser.

For example, you need to view details for each actor for all categories in the Sakila database. To do this, you should perform the following actions:

1. On the Database menu, click Master-Detail Browser.

2. Drag the required tables from Database Explorer to the designer area.

3. Select master table and click on the toolbar pane of the master-detail document.

4. Link columns, if needed.

5. Select checkboxes near the columns you want to be included into the results and clear the checkboxes near the columns you don’t want to be included into the result.

6. Click on the toolbar pane.

7. Navigate between the records in the master table and click + to view the detail data.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for PostgreSQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for PostgreSQL?
Download a free 30-day trial