Kendall,

I think this is a bug in the view designer. You'll probably have to code this view manually using CREATE SQL VIEW.

>Hi All
>
>I used the view designer to create the following SQL statement.
>
>SELECT Master.*, Equipment.eqp_nameck, Manufacturer.mfg_nameck,;
> Modelno.mdl_modelnock, Stations.stn_nameck;
> FROM sm!equipment INNER JOIN sm!master;
> INNER JOIN sm!modelno;
> INNER JOIN sm!manufacturer;
> INNER JOIN sm!stations ;
> ON Stations.stn_pk = Master.mst_stationfk ;
> ON Manufacturer.mfg_pk = Master.mst_mfgfk ;
> ON Modelno.mdl_pk = Master.mst_modelfk ;
> ON Equipment.eqp_pk = Master.mst_equipfk;
> WHERE Master.mst_pk = ?lcMst_PK
>
>The problem I am having is that when I try to close and save the view, the designer says it can't find a particular column of the master table. But the column is there and a persistant relation exists in the DBC. In this case, Master.mst_stationfk.
>
>If I only have two tables joined to master, no problem. If I add a third table, then this situation occurs. Which ever table is added last, it will become the column that can't be found.
>
>Any idea's?
>
>Kendall