Results 1 to 5 of 5

Thread: Table Design

  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm making a tooling database using Access 2007.

    I first came up with how I will identify the ridiculous myriad of tooling we have here in a unique manner, which is very very difficult for me since I don't know all of the tooling intimately and we are basically a giant job shop that makes product of allllllll shapes and sizes. Anyway, I have some basic table questions on how the data should be organized since it's been a long while since I last touched a database. This is basically how I'm organizing the columns (to create unique records):

    Autonumber, Plant#, Machine, Bottom part, Bottom part special finish, outside part, inside part

    Now after that, the tooling uses repeatable parts, bushings and inserts to those bushings. These bushings & inserts are used for different machines which each have probably 50 records or so of unique data lines. If i were to put these bushings/inserts in the same table, I would change the 50 record lines to 500 lines or more. Should I make a new table with just the unique bushings/inserts and link them some how? I want the end-user to be able to select a tooling "package" and then pick the bushings/inserts they want to use for it. If something doesn't make sense, please let me know so I can try to clarify.

    Also, when I made the table my autonumber started at #9... why is that?!

    Thanks!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'd create separate tables for the unique bushings and inserts, a join table that contains the inserts used for specific bushings, and a join table that contains the bushings used for specific toolings.

    You may be able to reset the AutoNumber by deleting all records and compacting/repairing the database.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts
    what does the join table do exactly?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You have a many-to-many relationship between for example bushings and inserts. This is implementyed by creating a table that contains the combinations that occur. See this post for an example of how to handle data entry for a many-to-many relationship with a main form and subform, and see Micorosoft's document "Understanding Relational Database Design" for some background.

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans! Glad to see you're still a posting-powerhouse here
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •