Connecting/linking tables

[Beth]

I have 4 tables. One is a complete table containing info
from all other 3. How do I connect all the tables so that
if a change is made in any one, that the change is
reflected in the main or complete table????

 

[Van T. Dinh]

The problem is that your are *storing* redundant data and
it is hard (if not impossible) to keep redundant data
synchronised. In fact, Relational Database Design Theory
(RDDT) generally advises against storing redundant data
for this reason (and wasted storage space).

Suggest you read up on RDDT and restructure your database
to meet the requirements of the RDDT.

HTH
Van T. Dinh
MVP (Access)