Here is a modified version of the same problem. I fixed the reference to child1 twice but you still cannot modify the view in the designer.
************************
if not file("test.dbc")
create database test
endif
if not file("parent.dbf")
create table parent ;
( parentpk I, ;
parentname c(30), ;
child1fk I, ;
child2fk I)
endif
if not file("child1.dbf")
create table child1 ;
(child1pk I, ;
child1name c(30))
endif
if not file("child2.dbf")
create table child2 ;
(child2pk I, ;
child2name c(30), ;
child1fk I)
endif
create SQL view v_parent as;
SELECT parent.*, child1.child1name, child2.child2name ;
FROM test!parent INNER JOIN test!child1 ;
INNER JOIN test!child2 ;
ON parent.child2fk = child2.child2pk ;
ON parent.child1fk = child1.child1pk ;
WHERE parent.parentpk = ?lnparentpk
* will request a view parameter, enter any numeric value
use v_parent
browse && notice the child1name field
modi view v_parent