-
Copyrights 2010 - Online Training Oracle Applications. All Rights Reserved.
|
Relation between blocks can be established, without having constraints at database level. INSERT INTO EMPONE VALUES
CREATE TABLE DEPTONE INSERT INTO DEPTONE VALUES (10, 'ACCOUNTING', 'NEW YORK'); Note Create a block using wizard using parent table i.e. ( deptnone) Now,
File Save As DEPT_EMP.fmb Note When we establish Master-detail relationship between two blocks, the following triggers are created.
It is form level trigger. When we clear the master record, the corresponding child records are cleared automatically. Look at the following screen shot. Keep the cursor on the master block , Record à clear It is a block level trigger. ON-CHECK-DELETE-MASTER It will not allow to remove parent row when depending child row exists.
|