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

Wow. Read my reply to Barbara and see if this makes sense for you.

Ed