Databases Reference
In-Depth Information
How It Works
The Page Rendering section provides an overview of the back-end wiring of each page. It lists every field
used on the form and provides tools to manipulate every aspect of the fields from visual layout to
validation behavior.
2-4. Selecting from a List of Values in a Form
Problem
You need to create a List of Values (LOV) as a drop-down list for the Country field in the Customers form.
This LOV must be dynamic and should be managed in a separate table.
Solution
Here's how to create a form field allowing users to select from a LOV:
1.
Using the Object Browser tool in the
SQL Workshop
, create a new table named
Countries with two columns: CountryName and Remarks. Insert some sample
data into the tables; for example, create records for
Japan
,
US
, and
Singapore
in
the CountryName field.
Tip
Recipe 2-1 describes how to use the Object Browser tool to create tables.
2.
Navigate to the application home and click the Form on CUSTOMERS form.
This will display the page configuration area. In the Page Rendering section,
expand the Regions
Body (3)
Form on Customers
Items node and
double-click the Country field.
3.
In the ensuing page, change the Display As field type to a Select List. This
indicates a drop-down list. When you do this, you will also notice that a new
tab named List of Values will appear at the top. Click on this tab.
4.
In the ensuing page, click the Create Dynamic List of Values link. This will
launch a pop-up window that allows you to configure the dynamic list. In the
pop-up window, use the default table/view owner, and click the Next button.
