Automatic Updates

[Novice2000]

I have split one enormous table into 3. The demographic information is in
Table 1, data from 2008 in Table 2 and archived data in Table 3. The key is
the account number in each table. My problem is that when a new customer is
added their information is entered into Table 1, but a new record is not
added in the other tables. Is there any way to have all three table register
the addition of the new customer record without actually creating a new
record in each table?

 

[John W. Vinson]

I have split one enormous table into 3. The demographic information is in
Table 1, data from 2008 in Table 2 and archived data in Table 3. The key is
the account number in each table. My problem is that when a new customer is
added their information is entered into Table 1, but a new record is not
added in the other tables. Is there any way to have all three table register
the addition of the new customer record without actually creating a new
record in each table?

Ummmm... No. Of course not, and you certainly would NOT want to do so.

In fact having three "enormous" (how big? tens of millions of records is
"enormous") tables for the same kind of data is Bad Design; doing so will take
up more room than one table would (each table has its own overhead). Are the
tables in fact of the same structure? If not, how are they related? What is
the "data from 2008"?