Hi everyone,
I'm using Access 2010. Whenever I try to make an update query based on another table/query I seem to get this error:
Operation must use an updatable query. (Error 3073)
Let's say I have two tables:
TbA:
Inv PO
--------------
1 2
2 5
TbB:
Inv PO
--------------
1 3
2 5
Based on the field Inv (if they're the same in both tables) I want to update the PO of TbA with the PO of TbB so I tried this:
UPDATE TbA
SET TbA.PO = (SELECT TbB.PO FROM TbB WHERE TbA.Inv = TbB.Inv);
The fields "Inv" in both tables are guaranteed to be unique, so the SELECT query shouldn't be able to retrieve more than one record.
I don't understand why I get this error. My delete and insert queries work just fine, so I'm sure there can't be anything with writing rights or something.
Any help is appreciated.
Thanks
I'm using Access 2010. Whenever I try to make an update query based on another table/query I seem to get this error:
Operation must use an updatable query. (Error 3073)
Let's say I have two tables:
TbA:
Inv PO
--------------
1 2
2 5
TbB:
Inv PO
--------------
1 3
2 5
Based on the field Inv (if they're the same in both tables) I want to update the PO of TbA with the PO of TbB so I tried this:
UPDATE TbA
SET TbA.PO = (SELECT TbB.PO FROM TbB WHERE TbA.Inv = TbB.Inv);
The fields "Inv" in both tables are guaranteed to be unique, so the SELECT query shouldn't be able to retrieve more than one record.
I don't understand why I get this error. My delete and insert queries work just fine, so I'm sure there can't be anything with writing rights or something.
Any help is appreciated.
Thanks