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
Default

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.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
Reply With Quote