Ingres 11.0 | Using a Lookup Table Without a ListChoices Menu Item

Forms-Based Application Development Tools User Guide > Part 2: Vision > A. Vision Applications from a User’s Perspective > Using Lookup Tables and the ListChoices Operation > Using a Lookup Table Without a ListChoices Menu Item

Was this helpful?

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

Last modified date: 01/30/2023