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.

 

 

 

LINK MASTER and DETAIL

 

Based on foreign key establishment made already under table attributes,

 

the link will be displayed and leave the default and click NExT MASTER TABLE PRIMARY KEY DEFAULT

→ select existing trigger and click NEXT

 

DETAIL TABLE PRIMARY KEY DEFAULT

 

→ select existing trigger and click NEXT

 

DEFINE MASTER OPTIONS

 

→ leave the default values and click NEXT

 

CHOOSE LAYOUT

 

→ select Edit detail as tabular form on same page and click NExT PAGE ATTRIBUES

Page Title for page 7 may be modified as Voucher_details

 

→ Under breadcrump entry select parent entry as Transaction_menu

 

Click

 

NExT IDENTIFY TABS

select Use an existing tab set and reuse an existing tab within that tabset select Transaction-Menu under tabset click NExT

Identify the Vouchers as tab click NExT

 

allow the default button labels and click NExT allow the default branching page click NExT click CREATE under Master Detail Confirmation