>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