peskywinnets
Registered User.
- Local time
- Today, 15:49
- Joined
- Feb 4, 2014
- Messages
- 576
I have a very simple requirement..
I have a linked table & a local table ...they are joined.
I want to take some data from the linked table & update the local table with it, but I get this message...
"Operation Must use an updateable query"
Here's the SQL....
(the linked table is the table called QBSalesReceipt)
What bit of knowledge/nous am I missing?
I have a linked table & a local table ...they are joined.
I want to take some data from the linked table & update the local table with it, but I get this message...
"Operation Must use an updateable query"
Here's the SQL....
(the linked table is the table called QBSalesReceipt)
Code:
UPDATE QBSalesReceipt INNER JOIN Sales ON QBSalesReceipt.doc_num_h = Sales.doc_num_h SET Sales.ExchRate = [QBSalesReceipt]![exchange_rate_h];
What bit of knowledge/nous am I missing?
Last edited: