AnsweredAssumed Answered

Splitting up a Table with a large number of fields into multiple Tables with fewer fields

Question asked by GaryVogt on Jan 27, 2014

Title

Splitting up a Table with a large number of fields into multiple Tables with fewer fields

Post

     I have 2 Tables, Table_A and Table_B, in ONE large database with roughly 500 fields each.  Each Table controls it's own set of records.  It would be nice if I could break the large tables up into smaller tables (and still have it work).  Sort of like having many manageable subroutines in a large computer program.  

     I just tried to add Table_C with just the (17) date fields and relate it to the Table_A and Table_B.  Steps I took.

     • I added Table_C

     • I copied the date fields from Table_A into Table_C and deleted the date fields from Table_A.

     • I notice Table_C has no records.  

     This doesn't look like it's going to work.  

     Is it even possible to have multiple Tables controlling one set of records?

Outcomes