>>When I run the View Designer I get the following message when I try to quit the designed:
>>
>>SQL Column "Auth_code" is not found. There is an auth_code field in each of the tables that makes reference to them. I picked them with the designer. Here is the SQL code when viewed:
>>
>>SELECT *;
>> FROM calllink!faxque INNER JOIN calllink!schedule;
>> INNER JOIN calllink!pending;
>> INNER JOIN calllink!assigned;
>> INNER JOIN calllink!account ;
>> ON Assigned.actnum = Account.actnum ;
>> ON Pending.actnum = Assigned.toll ;
>> ON Faxque.audit_num = Pending.audit_num ;
>> ON Faxque.audit_num = Schedule.audit_num
>>
>>What is going on?
>>
>>Ed
>
>
>I made a Typo. The error is: "Audit_num" is not found.
>
>PS: How do you delete a thread when you discover an error afer you send it?
>
>Ed
Ed, the answer to the second question is "You don't" You just leave your mistake for everyone to see. It keeps us humble. (As if FoxPro didn't do a good enough job.)
As for the first question, was the typo in your code, so it works now or in the message so you still have a problem? The SQL looks okay to me....
Barbara