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

That's just what happens to me.
And what is unbelievable to me is that if I copy the sql statement in the query and
run it in a procedure , it sometime runs without giving any error.
I discovered that it is related by the number of tables in the query and I tell you more :
I run an SQL statement in an event of a form... It gives me this error only the first time
I call the form in the application.
I.e. if , without exing the application I run again the form it doesn't give any kind of error.
If you discover something more please let me Know.
Ciao
Alessio