Oracle Apex - Master Detail Form

1 - About

master detail

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.

A master detail form reflects a one-to-many relationship between two tables in a database.

See first Oracle Apex - Tabular Form

3 - Processing

3.1 - Rendering

When running a master detail form, data is rendered as a report using various form elements (including text fields, text areas, date pickers, select lists, radio groups, and so on).

On the Master Detail:

  • the master record displays as a standard form
  • and the detail records display in a tabular form at the bottom of the page.

4 - Creation

4.1 - Wizard

  • Create Application Wizard
  • Create Page Wizard

The Create Page Wizard provides support for creating a master detail from two tables that do not have foreign key relationship defined in the database.

5 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap