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
lookup_demo1.gif

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

3. Press the Auto-Create button then Yes to proceed
lookup_demo3.gif
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.
lookup_demo4.gif

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




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

Comments

No comments yet.