Try this in VFP.

********************************************************
create database test

create table parent ;
( parentpk I, ;
parentname c(30), ;
child1fk I, ;
child2fk I)

create table child1 ;
(child1pk I, ;
child1name c(30))

create table child2 ;
(child2pk I, ;
child2name c(30), ;
child1fk I)


create SQL view v_parent as;
SELECT parent.*, child1.child1name, child2.child2name ;
FROM test!parent INNER JOIN test!child2 ;
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
********************************************************

Now, why does the browse return that weird field name and why can't you modify the view?