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

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