update 2 tables with one form

C

crhp917

i am trying to have a data entry form in 2003 update 2 tables at the same
time, but it will only update one table, not the other. is there ann easy
way to fix this?
joe
 
J

John Vinson

i am trying to have a data entry form in 2003 update 2 tables at the same
time, but it will only update one table, not the other. is there ann easy
way to fix this?
joe
Click to expand...

How are the tables related? Typically one would use a Form for the
"one" side table of a one-to-many relationship, and a Subform for the
"many", using the linking field as the master/child linking field.

If you're trying to store the *same* data redundantly in two different
tables - you probably should reconsider your design, or at the very
least explain your reasoning.

John W. Vinson[MVP]
 
Top