LOV Wizard to create an LOV

• We can access the LOV wizard by selecting Tools – LOV Wizard from the main menu.
• The wizard will create the objects that comprise an LOV and will adjust the properties of these objects.
• The wizard only creates record groups based on queries; it cannot help you define static record groups.
• The wizard pages are:
• Source Page: the wizard will create a record group object along with the LOV object.
• SQL Query Page: The wizard will take the query you have written here and store it the record group’s.
• Column Selection Page: Begin to populate the new LOV’s Column Mapping Properties.
• Column Display Page: Populate the LOV’s Column mapping properties.
• Advanced Options Page: The wizard will set the Record Group Fetch Size property for the record group. It will also set the Automatic Refresh property ofr the LOV. It can also set the Filter Before Display property for the LOV.
• Items Page: The wizard will set the List of Values property to the item.
• Automatic Display Property will display the LOV as soon as the user navigates into it.