>Hello,
>
>I have done, (left join) 2 tables relation in view.
>
>order.custid on cust.custrefid
>
>when the relation is occured, view takes value in cust.custname by the order.custid
>
>But if custid and custrefid arent equal or if there isn't any value custid, view takes .null. so it can not be changed or deleted. How can i provide, string value instead of .null. or doesn't care the .null. ?
>
>Note: The error message is below
>No key columns are specified for the cupdate table "mydbc!cust". Use the Keyfieldlist property of the cursor.
Okan,
Do not send the updates. Do the update manually (never update from a view to multiple tables IMHO).
Cetin