AnsweredAssumed Answered

Split one table 164 fields into several tables

Question asked by Storm on May 17, 2010
Latest reply on May 17, 2010 by Storm

Title

Split one table 164 fields into several tables

Post

New Here so pls. forgive ignorance. Over the years I have added fields to my database expanding inventory and now my one table has 164 fields, which makes it more and more difficult to manage - although it works. How do I remdodel the 1 huge table with 3000 records into 6 smaller related tables the fastest way? Do I import relevant record info from 1 old table into each of 6 new tables or what? I have laboured countless hours over this, so many thanks for help and input.

Outcomes