updating multiple tables

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

Guest

Hi,
I had created an inventory database where there are multiple tables, which some of the fields in each tables are the same (I had put relationship to all tables, as required).

I want to be able to put all the fields from different tables into one input form, and be able to update all the tables at the same time.
 
Hi,
I had created an inventory database where there are multiple tables, which some of the fields in each tables are the same (I had put relationship to all tables, as required).

I want to be able to put all the fields from different tables into one input form, and be able to update all the tables at the same time.
Click to expand...

No... you don't, I'm afraid!

Well, you may want to, but you shouldn't. A very basic principle of
relational database design is what I call the "Grandmother's Pantry
Principle": "a place - ONE place! - for everything, everything in its
place."

That is, if you have the same information being stored redundantly in
several tables, you're not using Access as it was designed. Store the
data ONCE and once only, and then use Queries, Combo boxes, Subforms
and the other tools Access provides to see the data from multiple
tables together.

If you have one to many relationships, you can use a Form for the
"one" side table with Subforms for the "many" side tables, both for
data entry and for viewing. This will automatically maintain the links
between tables; it's neither necessary nor wise to create empty
"placeholder" records. Just add new many side records when there is
data to go into them, and let the Subform take care of the linking.
 
Back
Top