Oracle APEX Master Details Tutorial

1- Master-Details Types

The lastest  Oracle APEX version at present (18-10-2015) is 5.0.1, a pity of this version is that it still does not allow you to create 2 Tabular-Form on the same page. It means that you can't create Master & Details  on the same page in which both of them are in  Tabular-Form. However,  Oracle APEX development team as promised that this limitation will be overcome in the upcoming version. And so you need to wait patiently. Now working with Master-Details you have 2 options:
  1. Master-Details, Master is Form and Details is Tabular-Form, edit on same page.
  2. Master-Details, Master is Form and details is Table,edit details on another page.

1.1- Master-Details with Master is form, details is Tabular-Form, edit on same page

Below slider imagine show you the website displays Master-Detail with Master in Form type, Details is Tabular-Form.You can easily create with the help of the Wizard.
  • SLIDER

1.2- Master-Details with Master is Form, details is Table, edit on another page

Below slider imagine show you the website displays Master-Detail with Master in Form type, Details is Table, create and modify records of Detail on another page. You can easily create with the help of the Wizard.
  • SLIDER

2- Create Master-Details with Wizard

Create Master-Details with the help of the Wizard
Select Master table is DEPT
Select detail table is EMP.
Wizard will ask you  "Include master report?":
  1. If you choose Yes, Wizard will create page list of records of Master which displays in tabular form ((Just see) and a page contain Master in Form and Details in Tabular-Form.
  2. However, if you choose No, only one page will be created with the Master in Form and Details in Tabular-Form.
Enter:
Master Page
  • Page Number: 10
  • Page Title: Master-Details (1)
  • Region Title: DEPT
  • Page Mode: Normal

Detail Page
  • Page Number: 11
  • Page Title: EMP
Master-Details has been created, you can test application.
You can modify the items displayed on the Tabular-Form into  "Select List" or   LOV, in Oracle Apex Tabular Form tutorial, I have guide specifically on this issue.
 
There are 2 pages which are created when you create a Master-Details by Wizard, as I mentioned above Oracle APEX does not allow you to create 2 Tabular-Form on the same page, at least for the current version ( Oracle APEX 5.0.1), we hope that this limitation will be overcome in the next versions.