Editing Items to Display as Select Lists

After you create the lists of values, edit these items so they display as select lists. By default, the items display as text fields.

You also rename the P4_JOB_ID, P4_MANAGER_ID, and P4_DEPARTMENT_ID items.

To edit the job item:

1. Under Page Rendering, scroll down to the Items section.

   
   Description of the illustration item_sect.gif
   
   

   Notice that the Items section lists all the items for this page. Currently all but two items show the default type of Text field.

2. Click P4_JOB_ID.

   The Edit Page Item page appears.

3. Under Name, select Select List from Display As.

4. Under Label, change Label to Job.

5. Scroll down to List of Values.

6. From Named LOV, select JOBS.

7. Click Apply Changes.

To edit the manager item:

1. Under Items, click P4_MANAGER_ID.

2. Under Name, select Select List from Display As.

3. Under Label, change Label to Manager.

4. Under List of Values:

   1. Named LOV - Select EMPLOYEES.

   2. Display Null - Select Yes.

   3. Null display value - Enter the following:

      - No Manager Assigned -
      

   Note that you did not include this information for Jobs because the Job column is mandatory. For optional columns, such as Manager and Department, specify that the select list display a null record. You can also provide meaningful text to display to the user when this situation occurs.

5. Click Apply Changes.

To edit the department item:

1. Under Items, select P4_DEPARTMENT_ID.

2. Under Name, select Select List from Display As.

3. Under Label, change Label to Department.

4. Under List of Values:

   1. Named LOV - Select DEPARTMENTS.

   2. Display Null - Select Yes.

   3. Null display value - Enter the following:

      - No Department Assigned -
      

5. Click Apply Changes.

6. Run the page.

   
   Description of the illustration bldap_empeditfrm_lst.gif
   
   

   In the form, note that the Job, Manager, and Department fields now display as select lists.