Creating an LOV by Using the LOV Wizard:
1. Launch the LOV Wizard.
2. The Welcome page is displayed after that click on Next.
3. Specify the LOV source in the LOV Source page. Select an existing record group or create a new one based on a query. New Record Group based on a query radio button is set by default. Then Click Next to select the default.
4. In the SQL Query page specify the query used to construct the record group.
- Click on the Build SQL Query button to use the Query Builder
- Click on the Import SQL Query button to import a query from a file.
- To enter the query directly, type the SQL syntax in the SQL Query Statement field. Then click on the Check Syntax button.
5. In the Column Selection page, select the record columns which you need to involve in the LOV.
Creating an LOV by Using the LOV Wizard (continued)
6. In the Column Properties page, specify the title, return and width value for every LOV column. Remember that the Return Value Into item is optional.
7. In the LOV Display page, specify the title, height, and width of the LOV window.
Creating an LOV by Using the LOV Wizard (continued)
8. In the Advanced Options page, set the further advanced properties. Which Specifies
- From the database number of records to be fetched
- To add criteria if the user should be presented with a dialog box before the LOV is shown.
- If the LOV records should be queried every time the LOV is invoked.
9. In the Finish page, click on the Finish to complete the LOV creating process.