When creating a database application, developers can create three basic form types: editable interactive grid, form on a table, or a master detail.
See Also:
Parent topic: Developing Forms
An interactive grid presents users with 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.
See Also:
"Using an Editable Interactive Grid" in Oracle Application Express End User’s Guide
Parent topic: Understanding Form Types
From on a Table creates a form that enables users to update a single row in a database table.
The following is an example of a form on table.
Parent topic: Understanding Form Types
A master detail form reflects a one-to-many relationship between two tables in a database. Master detail forms enable users to insert, update, and delete values from two tables or views.
Typically, a master detail form displays a master row and multiple detail rows within a single HTML form. 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.
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.
Parent topic: Understanding Form Types