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