Creating The Tabular Form

                  In this topic, you create a tabular form on the DEPARTMENTS table.


From the Application page, click Create Page.




Select Form and click Next.




Select Tabular Form and click Next.




Select DEPARTMENTS for Table/View Name. Make sure all the columns are selected and click Next.




Select Select Primary Key Column(s) for Primary Key Type, select DEPARTMENT_ID for Primary Key Column 1 and click Next.




Select Existing sequence for Source Type and select DEPARTMENTS_SEQ for Sequence. Then click Next.




Make sure all the columns are updateable (on the right side) and click Next.




Change Page Name and Region Title to Update Departments and click Next.




Select Use an existing tab set and create a new tab within the existing tab set and enter Departments for New Tab Label and click Next.




Accept the default button labels and branch pages and click Next.




Click Finish.




Click Run Page.




The Tabular form is displayed. You can change the data. Enter something in one of the Cost Center rows and click Submit.




The row was updated. You can also add a row. Click Add Row.




Enter a new departments information and click Submit.




The row was added. Note that the number of rows was incremented by one.You want to change the Manager id column so that it shows the Managers last name. Click the Edit Page button in the Developer Toolbar.




Under Page Rendering, double-click Update Departments.




Click the Report Attributes tab.




Click the Edit icon in front of the MANAGER_ID Column Attribute.




Change the Column Heading to Manager. You can use the same Shared LOV you created in the previous lab. Select Select List (named LOV) for Display As. Then select the List of Values subtab.




Select EMPLOYEE_LIST for Named LOV and click Apply Changes.




Click Run Page.




Notice the Manager column is now a select list with the last name of the manager. Click the Edit Page button in the Developer Toolbar. In the next topic, you add a tabular form validation.