View Single Post
  #2 (permalink)  
Old April 5th, 2006, 01:31 AM
AccessMaster AccessMaster is offline
Friend of Wrox
Join Date: Jul 2005
Location: Oklahoma City, OK, USA.
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts

All the data should be in a single table with a field for region. You do not need 19 tables, one for each region. This violates proper database normalization guidelines.

I would create a new blank with the correct table struture. Then link to the old databse and import the data into the new table using append queires.

"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
Reply With Quote