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
Kendall Webb
Senior Software Engineer
MCAD.Net/MCSD.Net