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. From Database Explorer, drag the actor, film_actor_id , and film tables to the designer area.
3. Select the actor table and click 
on the toolbar pane of the master-detail document.
4. Link columns, if needed.
5. Select check boxes next to the columns you want to be included into the results and clear the check boxes next to the columns you want to exclude from 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
Request a demo
