Mark ---
If it's a NULL, means there is no record to update, means you have an update conflict :-)
You're not going to be able to change NULL information from the right table with a LEFT JOIN query without a mechanism to append a record with matching keys but that goes beyond what you can do in the Command Window.
>I have a view with Left Join. Left table has a record but right table does not. So I see some fields with data some with .NULL. I type in and then try to update and a message 'Update conflict' pops up. Both tables have key fields. What I am doing wrong?
>Thanks Mark
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05