>Hello Group,
>
>I have a remote view that combines two tables linked by the primary key in
>the parent as the foreign key in the child. The update criterea page in the
>view designer has the following:
>
>Tables: All Tables
>
>Key field is the fk of the child ( I don't want to update the parent)
>
>Update all
>
>Send SQL updates is checked
>
>SQL WHERE clause includes:
>KEY and modified fields
>
>UDATE USING:
>SQL updates
>
>I used the one to many wizard to build the table. When I select edit the
>field value accepts my change but when I click save it reverts back to the
>original value.
>
>All of the permissions in the tables are checked in SQL Server 7.0
>
>What do I need to do to get the tables to take the updates. I am the only
>user on a stand alone machine.
>
>Thanks
>Jim
I would suggest you to start with a simpler view (e.g. with one table) and try the update from that view. If that works, then move to the 2 views tables.
You might want to consider to generate the code for your view (with GenDBC) and review that all properties of the view are set to what you expect. I've found sometimes that the view designer shows one thing but inside the view, in the view's properties, the value are just not right (e.g. the list of tables to update sometimes includes both tables when in fact you only want to update one.)
Hector Correa