I am attempting to create a view involving three tables in two different .DBC's in VFP 5.0.
When I attempt to save the view I get the following message:
SQL: Column CPROJRCWK is not found
This is the SQL generated by the Designer:
SELECT Qcrvaria.*, Qcr.crecordnumber, Projrcwk.csequence,;
Projrcwk.cdescription, Projrcwk.mtext;
FROM sitestat!qcrvaria INNER JOIN sitestat!qcr;
INNER JOIN pas!projrcwk ;
ON Qcrvaria.cprojrcwk = Projrcwk.cprojrcwk ;
ON Qcrvaria.cqcr = Qcr.cqcr;
ORDER BY Qcr.crecordnumber, Projrcwk.csequence
The field CPROJRCWK is the primary key in the PROJRCWK table and is a foreign key
in the QCRVARIA table and it most definately is found in both. Has nay seen this one and
is there a workaround. Please contact me at
bcogswell@networkbta.com if you have any advice.