How to view 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 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.

Master-Detail Columngs

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.

Master-Detail Result

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

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
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 SQL Server?