>Hello:
>I am trying to use an updatable view with a left join. I have
>two tables-PErsonel, address. I am left joining address on personl
>so I will have null records in my view -when
>someone from personel doesn't have a record in address.
>--YOu can't update the view b/c it won't automically
>insert a record into address-it says" update conflict"--
>Solution???
My rule is to update only one table at a time. Of course, I join data from several tables in views, no problem to that,
but I put only the "main" table fields as "updatable", and of course, the primary key as "key".
José