9.1 Understanding Form Types
When creating a database application, developers can create three basic form types: editable interactive grid, form on a table, or a master detail.
Topics:
See Also:
9.1.1 Editable Interactive Grid
An interactive grid presents users a set of data in a searchable, customizable report. In an editable interactive grid, users can also add to, modify, and refresh the data set directly on the page. Functionally, an interactive grid includes most customization capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse.
The following is an example of an editable interactive grid.
Description of the illustration GUID-3998E1C0-0135-43D9-B1D5-14FBDD92B321-default.png
See Also:
"Using an Editable Interactive Grid" in Oracle Application Express End User’s Guide
9.1.2 Form on Table
Creates a form that enables users to update a single row in a database table. You can choose a table on which to build a form.
The following is an example of a form on table.
Description of the illustration GUID-37125835-1579-45EC-B6F4-74A67D425E77-default.png
9.1.3 Master Detail Forms
A master detail form reflects a one-to-many relationship between two tables in a database. Typically, a master detail form displays a master row and multiple detail rows within a single HTML form. With this form, users can insert, update, and delete values from two tables or views. In Oracle Application Express, developers can create a single page or two page master detail.
Single Page Master Detail
A single page master detail features two editable interactive grids based on two related tables or views. Users select a row on the master grid to update the detail grid. In this example, the user selects a department on the master grid to view employees in the detail grid. Developers can create a single page master detail with either the Create Application Wizard or the Create Page Wizard.
Description of the illustration GUID-4387D49C-3C96-46A5-B5FD-DF7B54EC239A-default.png
Two Page Master Detail
A two page master detail features two pages based on two related tables or views. The first page is a non-editable interactive grid. Users click the Edit icon on the first page edit access details on the second page. The second page includes both a form and editable interactive grid. Developers can create a two page master detail with Create Page Wizard.
In this example, users click the Edit icon to view all employees within a department. The second page includes a form with details about the department and editable interactive grid of employees.
