How to use the new Lookup Feature

The example below uses the Microsoft Adventureworks sample database. It demonstrates how to create the lookup information automatically from the foreign keys defined in the database.

1. Connect to the database

2. Select Data, Manage Lookups from the menu.
There are presently no lookups defined so the feature is unavailable on every column.

3. Press the Auto-Create button then Yes to proceed
Now there is a lookup configuration created for every foreign key field in the Adventureworks database.

4. To perform a lookup Right-click a selected cell or cells in a foreign key field when displaying table data. Chose the Lookup menu option to pop-up a window of data from the other table referenced by the foreign key.

You can display more than one lookup at a time and even lookup fields in the popup window,

Last edited Mar 31, 2014 at 8:06 PM by Dave999, version 4


No comments yet.