Re: Forms3 ERR - unable to INSERT record

>You cannot use Forms to insert or update data in a view. Forms acutally
>uses the rowid field when performing these tasks and there is no rowid
>field for a view. Views are only useful for query only blocks.
>
>You are going to have to break up the blocks so that the block you which to
>insert from has a base table which is a true table, not a view.
>
>
You can use forms to insert, update, or delete data through a view (defined as a base table in forms) even if that view is a multi table join. You must however control the locking , inserting,updating and deleting through the following triggers. ON-LOCK,ON-INSERT, ON-UPDATE & ON-DELETE. This is a useful feature in Client-Server programming to minimise the number of packets required to display a "block" of information.

-- 
Shane Hocking       srh_at_scammell.ecos.tne.oz.au