Table of Contents

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

Processing

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.

Creation

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.

Documentation / Reference