Simple Select Query not updateable???????

  • Thread starter graeme34 via AccessMonster.com
  • Start date
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 ??
 
G

graeme34 via AccessMonster.com

Its Ok now.....I think Ive found the answer in a previous post......it
appears multi-table queries are not always updatable....I suppose I'll have
to have two queries...updating/editing them seperately..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top