I've heard of this problem when you create a view with the View Designer. The only solution I know of is to take your view out of the View Designer (with GenDBC) and do it in code, or with one of the third party view editiors like Eview or ViewEdit. The problem is that the code the view designer generates is marking the second table as updateable even though it isn't supposed to be.
>Hello:
>
>I just created a view whose updateable fields belong to Table1 except for one of them which belongs to Table2.
>
>The field from Table2 is not marked as updateable, then I expect no update done to Table2.
>
>However when adding a new record to this view. I get the error “Can’y insert an empty row…” when issuing TableUpdate (Buffering = 3). This comes from the field from Table2 which is use on some other instances to check its contents.
>
>Is it possible to have VFP from trying to add a new record to Table2?
>
>Thanks in advance for any feedback and regards.
>
>Oscar Corte