Building a Master Detail Form

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.

To create a master detail form:

On the Database Home Page, click the Application Builder icon.
Select an application.
Click Create Page.
Select Form.
Select Master Detail Form.

The Master Detail Wizard appears.
On Define Master Table:
1. Select a table or view owner.
2. Select a table or view name.
3. Select the columns to display.
On Define Detail Table:
1. Specify to show only related tables.
2. Select the table or view owner.
3. Select the table or view name.
4. Select the columns to display.
On Define Primary Key, select the primary key column for the master table, and then select the primary key column for the detail table.
On Define Master and Detail, define the relationships between master and detail tables.
Specify the source for the master table and detail table primary key columns.
On Define Master Options, specify whether or not to include master row navigation.

If you include master row navigation, define navigation order columns. If a navigation order column is not defined, the master update form navigates by the primary key column.
On Choose Layout, specify the layout of the master detail pages.

You can include the master detail as a tabular form on the same page, or add the master detail on a separate page.
On Page Attributes, review and edit the master page and detail page information.
On Identify Tabs, specify whether or not to include an optional tab set.
Click Create.