-
July 10th, 2012, 07:32 AM #1Junior Member
- Join Date
- Jul 2012
- Posts
- 1
MSAccess: think I need to split a large table; newbie question
I have a large table of individual herbal formulas that needs to be split (I believe) because I am bumping up on my maximum number of fields. I am sure performance will be better also but that is not my main need. Any help is greatly appreciated and I apologize for what is probably a pretty mundane and simple question for you all.
My table focuses on individual formulas with Chinese and American names with a counter primary key. I have fields for 20 individual ingredients and related fields for each of those ingredients such as dosage and preparation. Thus I already have 80 fields there. The other fields of the table relate to aspects of the formula from different textual sources.
I figure the data should be split into a main table with the names, counter, and most often used fields - a table for all the ingredient specific fields, and one or more tables for the different source information fields.
I plan to copy the original table multiple times - delete the repeated fields and relate the newly created tables to the original main table through one-to-one relationships via the ID field {the automatic counter key field in the table of individual ingredients; where these records will be used many times in many different formulas within the table I am seeking to split and which I plan to choose via a lookup field [via alphabetical list] in the formula table I am seeking to split}.
Is this basically correct or am I missing something? It is surely inelegant but I am concerned to not make any mistakes before I do a great deal of typing.
I am trying to make sure this won't mess up when I go to add a new formula which I assume I will do in the original main table (among the tables I created by splitting and not the separate ingredients table).
And it is easy right now to get the information sorted when it is just one table. I want to make I can still sort these parameters correctly and take advantage of all the typing I will soon do. Will I be using more complicated multiple table queries to get at my information in the future and am I setting up my structure correctly to accomplish this easily?
Am I going about this the right way? I want to make sure before I go ahead and fix something that isn't quite broken yet.
TIA for any and all info or direction to other resources that may answer my question.Last edited by howste; July 30th, 2012 at 10:41 AM.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Table Question
By Cook_1 in forum Webmastering and ProgrammingReplies: 6Last Post: December 5th, 2004, 06:04 PM -
MySQL mass delete from LARGE table
By Siliconjunkie in forum Applications and Operating SystemsReplies: 3Last Post: July 3rd, 2004, 05:46 PM



LinkBack URL
About LinkBacks



Reply With Quote

that was easy, if only deleting the partition was that simple.
Is It Just Me? v233893843