Elyse,
If you're adding records you need to set the keyfield updateable unless the key is generated automatically. Could this be the problem?
>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,