Modifying the Query SELECT Statement for an Existing LOV
To modify the query SELECT statement for an existing LOV:
- Select the LOV in the Object Navigator.
- Select Tools | LOV Wizard.
- Click the Record Group tab at the top of the
Wizard.
or
- In the Object Navigator Record Groups node,
double-click the object icon next to the record group on which the desired
LOV is based to display the Property Palette.
- Under the Functional node, change the Record
Group Query property appropriately.
Note: Any other LOVs based on this record group may be affected by the change to the record group's query. Using the LOV Wizard enables you to create automatically a new record group based on the modified query and base the LOV on this new record group.
Related topic
LOV Wizard: Record Group page