update query/one-to-many relationship tables

  • Thread starter Thread starter diann
  • Start date Start date
D

diann

this is a repeat post, since the answer provided by Julie
was insufficient - sorry :(

I have two tables in a one-to-many relationship. What
would be the best way to write a query so if Many.Field1 =
a specified value, that Many.Field2 is updated with the
value contained in the One.FieldX.
 
Hi diann,
sorry, but your post is so vague that it is impossible to provide a
sufficiently reasonable answer. What are your relevant table structures, and
how are you inserting your data? Are you using Forms/subforms, or are you
working directly in the tables? Post back to this thread if you'd like some
help.
Jeff
 
Back
Top