This query works fine...

SELECT exp.ID AS [REC_ID], exp.date AS [Date], cat.description AS Category, est.name AS Establishment, Choose(exp.payment+1,'Cash','Credit Card','Check') AS [Payment Mode],
Choose(exp.payment+1,crd.company,'N/A','N/A') AS [Credit Card], exp.amount AS Amount
FROM tblCreditCards AS crd RIGHT JOIN (tblCategories AS cat RIGHT JOIN (tblEstablishments AS est RIGHT JOIN tblExpenses AS exp ON est.id=exp.establishment) ON cat.id=exp.category) ON crd.id=exp.credit_card
ORDER BY exp.date;

...but why can't I delete a record from an ado recordset?

is it because of the RIGHT JOIN? or how the tables where arranged in the JOIN statement?

by the way...this is the error...


Run-time error: '-2147467259 (80004005)'

Insufficient key column information for updating or refreshing.


Thanks a lot!