Guidelines for Using Lookup Tables
Observe these guidelines when you use Lookup tables in your visual queries:
• Use Lookup tables with Append, Browse, or Update frames only.
• The column that activates the Lookup table must be displayed as a field on the form.
Vision creates this field as mandatory--that is, the user must enter a value. You can edit the form to allow the user to skip over this field.
• Include a total of up to eight Lookup tables for a frame that has a Master and a Detail table.
If your visual query does not use a Detail table, you can include nine Lookup tables.
• The Lookup table can share only one join column with the table for which you specify it; this is the column that activates the Lookup table.
To activate the same Lookup table on more than one column, you must include the Lookup table in the visual query for each of the columns. Each occurrence of the Lookup table counts toward the total number of tables allowed.
• If the selection list for a Lookup table is too wide to display as a pop-up window, Vision displays it as a full window.
• Vision makes the Top, Find and Bottom scrolling operations available to the user to move through a selection list; however, these operations do not appear as menu items.
• The user cannot perform any data manipulation operations (for example, update or delete) directly on a selection list.