Databases Reference
In-Depth Information
Figure 3-13.
The cascading relationship in action
How It Works
You can easily specify the List of Values (LOV) returned in a dynamic drop-down list using PL/SQL in the
List of Values tab of the
Select List
page item.
You might also have noticed that you can reference form fields directly in your PL/SQL code using
the :ItemName syntax (a colon, followed by the name of the page item). This allows you to create
dynamic PL/SQL code that uses data keyed in from the form on the fly for further processing.
3-5. Disabling or Hiding a Section of a Form Dynamically
Problem
You have a list of fields on a standard form you wish to hide (set invisible) depending on what was
specified in another field. Taking the sample employee table in Recipe 3-2 as context, you might choose
to hide the employee's Social Security number if the employee type was keyed in as LOCAL.
Solution
To create a dynamic action to hide a section of a form, follow the following steps:
1.
Create a database application/standard entry form from the EMPLOYEE table
from Recipe 3-2.
