Why is this not updatable?

[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'));

 

[Dale Fye]

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