Oracle Forms

Hi,

I am new to forms and am trying to modify an existing form which currently works in the following way :

The same form is used for insert/updates/queries.

The data block is based on a table and a post query trigger is written which updates the other text items on the canvas(which come from different tables) based on the values returned by the data block. Since the query functionality is based only on the table, you cannot query on the other items that are on the canvas. I need to make the query work on the other items that come from different tables.

I created a view which joins all the tables but when I query although it returns the right record I get an error message " Cannot insert into or update view"

I'm not sure what the best way to resolve this is ?

Any suggestions ?

Thanks
Preeti