Linking records

[Command One]

I created a main database table; name, address, phone#, etc. I want to link
other tables to the main table. Whereas if I input new information into the
main table, it will update information in the tables link to it. The other
table will have the names for the main table but no the address and phone#.
Is this possible.

 

[Tom Ellison]

Dear Command:

It may be possible, but not very simple. That's why this isn't the way it
is done.

Instead, do not duplicate this kind of information in any ordinary
circumstances. Instead, build a query that "links" (JOINs) the tables, so
the the related data from other tables is instantly available without the
need for making copies of things in multiple places. This is the way
databases are constructed. Indeed, the technology in which we work presumes
you will do it this way.

Tom Ellison