>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.

View designer cannot handle properly complicated views. Use CREATE SQL VIEW to create view programmatically and CURSORSETPROP() to handle its properties.