update 2 tables with one form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
New Version of Invisible Controls In Form View/DE "No" Prop Issue 0
Separate Form 0
Table within a form 2
Update 3 tables w/ 1 Form 2
Help with form load 5
Using form and subform not connecting to two separate tables 0

Back
Top