How to link two tables so they update each other?

[epb613]

Hello,

I have this table that I currently use that's now grown to over 300 columns wide, and I want to split it up into two (and in the future, multiple) smaller tables. Basically, each record represents an account number, and the columns contain information about the account. I would like to split it into two tables linked on account number, and I can put half the columns in one table and half of the columns in another. My hope in splitting them is to speed up the multiple queries that I run on them all day long.

What I can't figure out how to do is link the two split tables so that if I add a new account to one table, a corrosponding row will be automatically added to the other table. Is there a way to do this? I want the row to be added automatically, so that when I open the other table, I will see a list of the new accounts that need to have their information filled in.

Thanks so much!
Pinny

 

[jackd]

You should research Normalization and Entity relationship Diagramming.
Here are some links:

http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452 Database design principles

Database normalization - Wikipedia, the free encyclopedia

http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

http://www.rogersaccesslibrary.com/forum/uploads/5/12-Steps_to_Better_Databases.zip