Update 3 tables w/ 1 Form

  • Thread starter Thread starter RC
  • Start date Start date
R

RC

I'm new to Access, and am figuring my way around it. I've tried to update
multiple tables with one form, but haven't been able to do it. I've split
the tables in accordance with Normalization Forms, at least to the best of my
understanding. So, is there a way that more than one table can be updated and
accessed by a single form?
 
While it's possible to create a query that joins the three tables together,
it's difficult to make such a query updatable. (see what Allen Browne has at
http://www.allenbrowne.com/ser-61.html if you want to try...)

The normal way would be to have subforms on your form, each one bound to a
different table.
 
It's a bit tough coming up with a specific suggestion without an example.

When you say "multiple tables", what are you storing in those tables? How
are they related?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top