Create tables so it updates details anutomatically on another tabl

J

JODIE

Is it possible to set up tables in a way that if for example contact details
for a student was changed on one table the contact details on a different
table would automatically update for that student?
 
W

Wayne-I-M

Hi Jodie

Yes it is - BUT - you should not have the student contact details in 2
tables - just one.
 
J

John Spencer

Not at the table level.

You would have to do all data entry via a form and have VBA code in the form
to force the update in the "other" table. If you were importing data, you
would need to have code in the import routine to handle the update.

That said, there is (almost always) NO reason to have the same information in
two different tables. This is an indicator of a bad database structure. You
should have one table that stores contact details and access that information
by linking to the table.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
J

John W. Vinson

Is it possible to set up tables in a way that if for example contact details
for a student was changed on one table the contact details on a different
table would automatically update for that student?
Click to expand...

Possible? yes.

A good idea? *Absolutely not*.

Storing the same data redundantly in two tables goes against all relational
principles. Relational databases use the "Grandmother's Pantry Principle" - "A
place - ONE place! - for everything, everything in its place". The contact
information should exist ONLY ONCE.
 
Top