Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

 

 

 

 

 

 

 

36-HOW TO CREATE MASTER-DETAIL FORM

Application Builder

 

Select Application

 

→ Edit Page 6 Ledger-Master

 

Page Rendering

 

→ Region section click create Button

 

→ select Form Click NEXT

 

→ select Master - Detail Form Click NExT DEFINE MASTER TABLE

Leave owner default

 

→ select Table Name as Raak_Trans_Master ( all the columns will get displayed in  available columns, using '>>' icon shift all the columns to displayed columns click NExT

DEFINE DETAIL TABLE

 

Leave default Yes against Show only related tables

 

Leave the default owner against Table Owner

 

→ select the Raak_Trans_Detail against Table Name will display all the columns in available columns and push all the columns to displayed column box click NExT

DEFINE PRIMARY KEY

 

→ leave the selected default values click NEXT