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,
Elyse Pomerantz