Was this helpful?
Qualification Processing
By default, when the user calls a Browse or Update frame, the displayed form is blank. The user enters a query qualification, then selects Go to retrieve selected records from the database. For example, if your application uses a large table of customer information, users can enter qualifications to locate a particular customer record quickly.
User qualifications can be in addition to or instead of query restrictions that you specify when you define the frame. Users cannot enter query qualifications on Detail tables; they can enter qualifications for Master tables and Lookup tables only.
Change the user query qualification default so that the Browse or Update frame displays the first appropriate record from the Master table and Detail table, if any. This record can be any of the following:
The first record that satisfies any query restrictions that you specify in the frame definition
A specific record containing values passed as parameters from the parent frame (for details on passing parameters, see Passing Parameters Between Frames)
For example, a user can view a customer record on a Browse frame (the parent frame), then call an Update frame to display the same record to update.
The first record stored in the database, if you do not use either of the above methods
Disable qualification processing when you want to pass parameters from a parent frame to a child frame. The parameters passed become the query qualifications for the child. In this way, the application controls which record the user sees; when qualification processing is disabled, the user cannot enter a query qualification to retrieve any other record.
If you disable qualification processing, you cannot use a Lookup table to provide a selection list, because the user cannot select the data to be displayed. However, you can use a Lookup table to enter data values into fields on the form. See Including Lookup Tables in Visual Queries for details.
Last modified date: 01/30/2023