V
VMI
Why do I get "operation must use an updateable query." when trying to run
the following query?
update audit a
set a.RefFBU = (select reference.RefFBU from reference where
reference.RefKey = a.InKey)
They're both text fields and about 500 of the records match with a Select
qry.
Thanks.
the following query?
update audit a
set a.RefFBU = (select reference.RefFBU from reference where
reference.RefKey = a.InKey)
They're both text fields and about 500 of the records match with a Select
qry.
Thanks.