Paul,
You need to have the PK fields for both parent and child avaiilable, and marked as key fields. Check to be sure you've met both conditions.
HTH
Barbara
>i have a view that combines data from two vfp tables.
>
>the tables are related through a foreign key and the fk's are
>used as the inner join condition between the tables. here is
>how my code looks...
>
> create sql view MYVIEW ;
> as select ;
> TABLE1.PK , ;
> TABLE1.FK , ;
> TABLE1.COLUMN1 , ;
> TABLE1.COLUMN2 , ;
> TABLE1.COLUMN3 , ;
> TABLE2.COLUMN1 , ;
> from TABLE1 ;
> inner join TABLE2 ;
> on TABLE2.FK = TABLE2.PK
>
>i displayed the rows from the view in a grid.
>
>i can edit TABLE1.COLUMN2, TABLE1.COLUMN2, TABLE1.COLUMN3 and
>successfully update the base table. when i edit TABLE2.COLUMN1 the
>tableupdate fails.
>
>i have tried different combinations of dbsetprop and cursorsetprop
>calls to set the tables and fields that can be updated but i have not
>had any luck.
>
>thanks in advance for any insight on this...