G
graeme34 via AccessMonster.com
Hi I have a simple select query that is for some reason not updateable
SELECT RI.*, GRD.LineTotalCorrect, GRD.ProductCode
FROM tblReceiveInvoice AS RI INNER JOIN tblGoodsReceivedDetail AS GRD ON
RI.PurchaseOrderNumber = GRD.PurchaseOrderNumber
WHERE GRD.LineTotalCorrect=True AND RI.ReceiptNumber=17;
I have even taken out the WHERE clause and it is still un updateable???
does anybody know why this would be ??
SELECT RI.*, GRD.LineTotalCorrect, GRD.ProductCode
FROM tblReceiveInvoice AS RI INNER JOIN tblGoodsReceivedDetail AS GRD ON
RI.PurchaseOrderNumber = GRD.PurchaseOrderNumber
WHERE GRD.LineTotalCorrect=True AND RI.ReceiptNumber=17;
I have even taken out the WHERE clause and it is still un updateable???
does anybody know why this would be ??