+ Reply to Thread
Results 1 to 1 of 1
  1. #1
    Junior Member
    Join Date
    Jul 2012
    Posts
    1

    Question 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

  1. Table Question
    By Cook_1 in forum Webmastering and Programming
    Replies: 6
    Last Post: December 5th, 2004, 06:04 PM
  2. MySQL mass delete from LARGE table
    By Siliconjunkie in forum Applications and Operating Systems
    Replies: 3
    Last Post: July 3rd, 2004, 05:46 PM

Tags for this Thread

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Recommended Sites: ResellerRatings Store Reviews