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...