Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm trying to decide on how I want a tooling database that I'm creating to work. I've got a table for each type of tooling, since they are all different, and I want to be able to find any specific type of tooling by giving the user the power to narrow down what they are looking for. So for instance - I'd like to have a combo box that has 3 or 4 options in it to determine how to start the search off: Machine, Tooling type, End product, or Department. Then depending on which option was chosen, I want to populate the next combo box with what options are associated with the first search criteria. So "Tooling type" might be: Top Plate, Bottom Plate, Outer ring, etc.

    I'm thinking I should just start with a blank form and start creating this using a select/case code behind it to populate the combo boxes, and then maybe I can create a query based on the previous choices made. So first - is this "good" database design? And second - is select/case the right way to do this?
    <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
    Even if the toolings are different, I'd still prefer to use a single table.

    I'd create a series of tables that list the options, then use cascading combo boxes - see Basing one combo box on another and the links provided there (although the articles are for Access 2000-2003, they should apply to Access 2007 too).

    See Post 132267 for an example.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='772568' date='27-Apr-2009 21:23']Even if the toolings are different, I'd still prefer to use a single table.

    I'd create a series of tables that list the options, then use cascading combo boxes - see Basing one combo box on another and the links provided there (although the articles are for Access 2000-2003, they should apply to Access 2007 too).

    See Post 132267 for an example.[/quote]

    oh great, thanks for that link!

    as to using 1 table - what is the benefit behind doing it that way? Is that to avoid repetitive columns across multiple tables?
    <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
    Yes, I assume that although they are different, there will be considerable overlap between the fields needed for each type of tooling.

    Also, using one table makes it easier to select different kinds of toolings if needed,

Posting Permissions

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