Oracle Apex - Master Detail Form

Card Puncher Data Processing

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





Discover More
Card Puncher Data Processing
Oracle Apex - (Sql) Report (RPT)

A report can shown data as: mutable columns: When running a master detail form, data is rendered as a report. A tabular form is rendered as a report havingupdatable columns shown using various form...
Card Puncher Data Processing
Oracle Apex - Form

Forms are made up of fields (called items) stored procedure table or view query web service Master Detail form Tabular (Multiple row update) Summary (read-only form)



Share this page:
Follow us:
Task Runner