Morning everyone,

I'm trying to create a view that brings together data from 8 different tables in my database, using the view editor everything went smoothly until I tried to browse or modify the saved view, at which point I would receive a "SQL: Column 'TEN99BOXID' is not found." error, yet if I browse it again, it works??

I've reconstructed this view about 20 times with the same result, the SQL looks ok to me, I even tried building the view up in stages, checking it after adding each table and got the same error after adding a 3rd table, so it's as though it doesn't like multiple joins on more than 2 tables, but maybe I'm going through my mid-life crisis early (23), please help by shedding some light on my dilema.

Thank you,

- Aaron (Following is the SQL Statement)

SELECT Apvendor.vndid, Apvendor.vndcode, Apvendor.dfltcode, Apvendor.descr, Apvendor.addr1, Apvendor.addr2, Apvendor.frgnaddr, Apvendor.addr3, Apvendor.city, Apvendor.stateid, Apvendor.zip, Apvendor.phone, Apvendor.fax, Apvendor.email, Apvendor.internet, Apvendor.contact, Apvendor.status, Apvendor.vndremitid, Apvendor.termid, Apvendor.vndtypid, Apvendor.apacctid, Apvendor.expacctid, Apvendor.dscacctid, Apvendor.issue1099, Apvendor.ten99boxid, Apvendor.tinorssn, Apvendor.tin, Apvendor.chkmemo, Apvendor.ouracctno, Apvndremit.payname, Apvndremit.addr1 AS payaddr1, Apvndremit.addr2 AS payaddr2, Apvndremit.frgnaddr AS payfrgnaddr, Apvndremit.addr3 AS payaddr3, Apvndremit.city AS paycity, Apvndremit.stateid AS paystateid, Apvndremit.zip AS payzip, Apvndtype.vndtypcode, Apvndtype.descr AS vndtypdescr, Glacct.acctno AS apacctno, Glacct.descr AS apacctdescr, Glacct_a.acctno AS expacctno, Glacct_a.descr AS expacctdescr, Glacct_b.acctno AS dscacctno, Glacct_b.descr AS dscacctdescr, Smterm.termcode, Smterm.descr AS termdescr, Ap1099box.boxcode, Ap1099box.descr AS boxdescr FROM rwbs!apvndremit INNER JOIN rwbs!apvendor INNER JOIN rwbs!smterm INNER JOIN rwbs!apvndtype INNER JOIN rwbs!glacct INNER JOIN rwbs!glacct Glacct_a INNER JOIN rwbs!glacct Glacct_b INNER JOIN rwbs!ap1099box ON Ap1099box.ten99boxid = Apvendor.ten99boxid ON Glacct_b.acctid = Apvendor.dscacctid ON Glacct_a.acctid = Apvendor.expacctid ON Glacct.acctid = Apvendor.apacctid ON Apvndtype.vndtypid = Apvendor.vndtypid ON Smterm.termid = Apvendor.termid ON Apvndremit.vndremitid = Apvendor.vndremitid ORDER BY Apvendor.vndcode