Foreign key lookup

Foreign key lookup functionality opens table data basing on the link available in the cell. This functionality is based on foreign key relation between tables.

If you retrieve data of a table that has links based on foreign keys, you will be able to see data from the related table directly in Data Editor. The data of the parent table is shown if you click the down arrow button of the field you want to edit. The record of the parent table this foreign key corresponds to will be highlighted, as shown on the image below:

Foreign Key Lookup

Note
Actual document look may slightly vary from the above image depending on the product you use.

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?