Don't understand table link

[Maria Tracey]

If I have two tables like this :

====Table1=====
Name
Address
etc etc
==============

====Table2=====
Name
Company
etc etc
==============

Both tables have other fields also but to keep it simple I've just shown two
from each.

The tables are linked via the 'Name' field.

What I'm having a great difficulty understanding is that there are two forms
for entering information into each table.
If I add a record in table one how do I make sure that table 2 is updated at
the same time with the same record information in the 'Name' field.

I can't see how the two tables can remain linked if one table has been
updated and not the other.

Help please

Thanks
Jane

 

[Douglas J Steele]

You may be misunderstanding how relational databases work.

Updating Table1 is not supposed to have any affect on Table2.

If you're inserting a new record in Table1 and have data for Table2 relevant
to that Name, you have to explicitly insert to Table2 as well.

If you're changing something in Table1 for a particular Name, it shouldn't
make any difference to what's in Table2. If it does, then your database
likely hasn't been properly normalized.