update query/related tables

D

diann

I have two tables in a one-to-many relationship. What
would be the best way to write a query so that if Field1
in the "many" table = a specified value, that Field2 in
the "many" table is updated with the value contained in
the FieldX in the "one" table.
 
J

JulieD

Hi Diann

sounds like you need an update query ... have you checked them out in help
in Access? (topic "Change records as a group using an update query" in
access 2000 should get you started).

Cheers
JulieD
 
J

JulieD

sorry diann didn't notice the subject line too well on your post, i'm
guessing now that you want to write a query in vba maybe in a form that does
this on more than one occasssion - is this correct?

JulieD
 
Top