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