Why is this not updatable?

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

The following query gives the error:
"Operation must use an updatable query"

What is wrong here?

UPDATE PartNumbers a
Set Width =(Select Width from Partnumbers b where b.Partnumber = '108231')
WHERE (((a.PartNumber)='108231E'));
 
Darren

Try

UPDATE PartNumbers a
Set Width = DLOOKUP("Width", "Partnumbers", "Partnumber = '108231'")
WHERE PartNumber='108231E'

But why would you want to do this when you can get the width any time you
want by joining the tables. You are storing the same piece of information
in two different locations in your database, which is not good database
design.

HTH
Dale
 
Back
Top