I finally figured it out! The default setting for the "Tables" property, when the view is created in code, includes both tables. If I change this using CURSORSETPROP to include only MyTable before I delete the record, it works. It won't work if I change the property using DBSETPROP.

Thanks for all the suggestions!

>I just can't seem to get this to work. I have a view defined in code as:
>
>CREATE VIEW MyView AS ;
>SELECT MyTable.*, MyCodeTable.CodeDesc, MyCodeTable.Code ;
>FROM MyTable ;
>LEFT OUTER JOIN MyCodeTable ;
>ON MyTable.CodeValue=MyCodeTable.Code ;
>WHERE MyTable.ID=?AnotherTable.ID
>
>I set all of the fields as Updatable EXCEPT the KeyField in MyTable and the fields in MyCodeTable. I set SendUpdates to true. I played around with the "Tables" property. By default it lists both tables. If I change it to specify only MyTable, when I make changes to the view it doesn't update MyTable. If the Tables property lists both tables and I delete a record in MyView, it deletes the corresponding records in BOTH tables. All I want is to be able to update MyTable. It shouldn't change anything in MyCodeTable.
>
>What am I missing?
>
>Thanks for any help,