Your problem may be that if you include columns in two or more tables with the same field names in your selected fields clause, the resulting table/cursor will reassign the field names to something like fieldname_a and fieldname_b.

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