Left Outer Join SQL query Problem for Form source
Posted on 2004-03-22
Is is possible to use LEFT OUTER JOIN queries as a form source reliably in access?
whilse I can query the data, I am having all sorts of problems adding new records & editing records.
The SQL im trying to use is as follows.
SELECT id, acccode, tblPricing.itemcode, price, qty, tagqty, tag, blocked, description, unitsize, lastcost, gstcode FROM tblPricing LEFT OUTER JOIN tblTmpthinkpadinventory ON tblPricing.itemcode = tblTmpthinkpadinventory.itemcode WHERE tblPricing.acccode = 'ACAANN' ORDER BY tblPricing.itemcode, qty
the pricing table contains the records I want to edit/manage, the other table is just a stock file table that I am referencing the product descriptions from.
I get errors like the following when trying to edit or add.
"Method 'Fields' of Object _Recordset failed.