A. Vision Applications from a User’s Perspective : Using Lookup Tables and the ListChoices Operation : Using a Lookup Table Without a ListChoices Menu Item
 
Share this page                  
Using a Lookup Table Without a ListChoices Menu Item
There is one case in which you can include a Lookup table without Vision generating a ListChoices menu item or making a selection list available. This occurs if you create a Browse or Update frame and:
Include a Lookup table in the visual query
Display columns of the Lookup table as fields on the form
Do not allow users to enter a qualification on the form
When a user calls the frame, the user cannot enter a qualification and select Go to retrieve a record. Vision:
Displays the form with values already entered
Retrieves data into the form based on the values of the displayed columns of the Lookup table
Does not generate a ListChoices menu item for choosing from a selection list, because the user has no control over retrieving records onto the form