Hi,

Try using the eview utility in the downloads section.

HTH,
Arriyel

>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