How do I create a form to enter data to multiple tables?

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

Guest

I want to create multiple tables that have a relationship. Then want to
create a form that updates the appropriate table within the relationship when
data is entered. Is there a simple way to do this? I'm a novice.
 
BevB said:
I want to create multiple tables that have a relationship. Then want
to create a form that updates the appropriate table within the
relationship when data is entered. Is there a simple way to do this?
I'm a novice.
Click to expand...

Use a form with a subform. Each bound to a single table.
 
I'll try it next time. I gave up and put all fields in one table. Since I
created a form to enter all the data, it's a lot easier. Fortunately, I'll
only be updating once the initial data is entered. Thx!
 
Back
Top