I created one test complex view report form using two table emp and dept,
emp table is my key preserved table so my form can able to insert data only in emp columns i want to design as such it can update both tables.
CREATE OR REPLACE FORCE EDITIONABLE VIEW "EMP_DEPT" ("EMPNO", "ENAME", "DEPTNO", "SAL", "DNAME", "LOC") AS
SELECT emp.empno, emp.ename, emp.deptno, emp.sal, dept.dname, dept.loc
FROM emp, dept
WHERE emp.deptno = dept.deptno;
CREATE TABLE "EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
"JOB" VARCHAR2(9),
"MGR" NUMBER(4,0),
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0),
PRIMARY KEY ("EMPNO")
USING INDEX ENABLE
) ;
ALTER TABLE "EMP" ADD FOREIGN KEY ("DEPTNO")
REFERENCES "DEPT" ("DEPTNO") ENABLE;
CREATE TABLE "DEPT"
( "DEPTNO" NUMBER(4,0),
"DNAME" VARCHAR2(14),
"LOC" VARCHAR2(13),
PRIMARY KEY ("DEPTNO")
USING INDEX ENABLE
) ;
