updatable query

  • Thread starter Thread starter Lawrence
  • Start date Start date
L

Lawrence

Hi guru,

can anyone tell me what happen on my query below, it promt me "Operation
must use an updatable query"

UPDATE [Check 08 - Materials (with qty) but no Wafer Fcst] INNER JOIN ([Fair
Value] INNER JOIN [Inv Val Cur] ON [Fair Value].DID = [Inv Val Cur].[Design
ID]) ON ([Check 08 - Materials (with qty) but no Wafer Fcst].[Design ID] =
[Inv Val Cur].[Design ID]) AND ([Check 08 - Materials (with qty) but no Wafer
Fcst].[DID_Prod Cat_Pkg] = [Inv Val Cur].[DID_Prod Cat_Pkg]) SET [Inv Val
Cur].[Units Cost in Assm] = [Fair Value]![WIP Fair Value];

thanks in Advance
Lawrence
 
Any of those tables a linked table? I get that where when trying to
update a value FROM a linked table, and i have to build a local table
first and update from that.
 
Back
Top