Re: Oracle Forms with master-detail relationship

Greg wrote:

> I have a data block based on a view that joins 6 different tables.
> There are 20 fields displayed to the user. I want the user to be able
> to update 4 of the fields but this isn't possible with the view.

Of course it is. Just create an INSTEAD-OF trigger on the view. http://www.psoug.org/reference/library.html scroll down to "Instead-Of Triggers"

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)