How to view data in related tables

Last modified: October 1, 2024

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 actor, film_actor_id, and film tables from Database Explorer to the designer area.

3. Select the actor table and click Set Table as Master 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 Browse Data (F5) on the toolbar pane.

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

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!