Frank,
The View designer has limitations not found when you design a view from the command line, and working with multiple parent/child relations cannot be done.

You will need to work from the command box or write a small PRG to make your view.

Barbara

>CLOSE DATA ALL
>CREATE DATABASE 'db1.DBC'
>
>***** table F1 *****
>CREATE TABLE 'F1.DBF' NAME 'F1' (T1CODE C(2) NOT NULL, ;
> NAME C(10) NOT NULL)
>
>***** index for F1 *****
>SET COLLATE TO 'PINYIN'
>ALTER TABLE 'F1' ADD PRIMARY KEY T1CODE TAG T1CODE
>
>***** prop F1 *****
>
>***** table F2 *****
>CREATE TABLE 'F2.DBF' NAME 'F2' (T2CODE C(3) NOT NULL, ;
> NAME C(10) NOT NULL, ;
> T2T3CODE C(2) NOT NULL)
>
>***** index F2 *****
>SET COLLATE TO 'PINYIN'
>INDEX ON T2T3CODE TAG T2T3CODE
>ALTER TABLE 'F2' ADD PRIMARY KEY T2CODE TAG T2CODE
>
>***** prop F2 *****
>
>***** table F3 *****
>CREATE TABLE 'F3.DBF' NAME 'F3' (F2CODE C(2) NOT NULL, ;
> F1CODE C(2) NOT NULL, ;
> F3CODE C(3) NOT NULL, ;
> NAME C(10) NOT NULL)
>
>***** index F3 *****
>SET COLLATE TO 'PINYIN'
>ALTER TABLE 'F3' ADD PRIMARY KEY F3CODE TAG F3CODE
>INDEX ON F1CODE TAG F1CODE
>INDEX ON F2CODE TAG F2CODE
>
>***** prop F3 *****
>i want to make a view :
>crea sql view v1 as SELECT *;
> FROM db1!f1 INNER JOIN db1!f3;
> INNER JOIN db1!f2 ;
> ON F2.t2code = F3.f2code ;
> ON F1.t1code = F3.f1code
>I can make it in command line like above.
>but i cant make it in wizard, the msg is popup when i try to name the joins of it: 'you cant make a table to be 2 father tables' sub-table'.
>(origin in chinese)