update query/related tables

  • Thread starter Thread starter diann
  • Start date Start date
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.
 
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
 
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
 
Back
Top