Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008

    Unanswered: Complex relationships with different tables

    am creating a part numbering database for our small electronics firm. I have developed the part numbering scheme but, I am know looking to add specific components to a part number. Once you have entered the system it assigns a part number to you. I then have a menu to select the class of object (Mechanical, Electrical, etc…) then sub menu for category, then sub category till you get to the table that contains the component. How do I link the final table (component) to the original part number when you have travel several different tables to get to the final table and each part number could be assigned to a different component table? Each final component has a code that I want it to compare to other part numbers and their code to ensure I do not repeat a component under a different part number.


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Very clear.....

    How do I link the final table (component) to the original part number
    By means of a relationship... which is how you do all "linking" in Access
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    I think there are several different problems here
    1 is the generation of the part number
    2 is the associating back to the part
    3 is making sure the part hasn't already been defined.

    1 you reckon to have solved
    2 depends on the way you have modelled your data (we'd need to see the table defintions to be sure.. but my guess would be you use relationships to associate a part with its constituent categories. a RI associatiation should handle that
    3 is purely down to a mnual procedure, unless you part definition is that tight that you can derive its a duplicate part becasue the category data is similar.

    if the component code is made unique (create an index for that code) then you can ensure that from a systems perepective its unique, but yoiu can from a human perspective short of doing manual checks). Ive dsigned systems in the past where you force a user to search the db to look for duplicates (typos and the like). you cna use tools such as soundex or other metaphone based tools... although they are designed for predominantly anglo saxon/ western surnames they can be very good.. Izyrider as a double somehtign or other which he claims gives better results than soundex.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Oct 2004
    Melbourne, Australia
    Could you please clarify just what the part number refers to. It could be the component itself and that component belongs to a particular node in a tree of objects (class, category, etc.), or the component can belong to several different trees and can have a different part number in each family situation.
    In the first case, the part number would be assigned to the component when first entered and the component would then be assigned to whatever trees it is a member of afterwards. In the second case, the part number would be assigned to the component after traversing the tree, so that the part number not only identifies the component, but also the hierarchy it is a member of.
    Which is it ?

Posting Permissions

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