Dear All,

I have a HR schema in which near about 100 tables. Our application is developed in Forms/Reports 6i.

I have created new schema HR1 and create a view based HR schema tables with simle where condition. i.e.

e.g.

create view hr1.empsal as select * from HR.empsal where emp_id in
(select emp_id from HR.emp where location <> 'US');

Now when users try to do transaction one transaction able to do successful but when he navigate to next record and try to do another transaction he get the following error :

"cannot insert into or update data in a view"

Tables have master-details relationship.

Thanks in advance,

Nirav