Results 1 to 15 of 15
  1. #1
    Join Date
    Nov 2008
    Posts
    2

    Unanswered: Access design problem

    I have the following situation that is to be implemented in Access 2007. A field has to get its value from any level of a chain of linked tables. This chain of tables are linked in a such a way that the parent table is linked to a child table and this child table is further linked to child and so on up to 7 levels. How to come around this kind of a problem. How to make it possible for the user to select a value from any one of the levels and how to report the full path of the selected value.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    It is a little tricky to know the best method based on your description. Ignoring databases, could you describe the real world, business problem you are trying to model please? I could make some guesses and assumptions, but likely they would be wrong.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    kerching....!

    I think the design requirement for bharanidharanit's problem has just surfaced
    its building an SQL query using values culled from numerous list/combo boxes
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    bharanidharanit = mahdi4k???
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Yes - I knew you meant that thread. But are you saying these guys are the same person, are working on the same project, or just happen to have the same problem?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    It does at least reassure me that there is enough ambiguity to not attempt an answer - my first reading was this is an implementation of a 7 level deep hierarchy.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by pootle flump
    Yes - I knew you meant that thread. But are you saying these guys are the same person, are working on the same project, or just happen to have the same problem?
    we are in RFH season....
    the middle bit
    I'm guessing same class, possibly same curriculum, but too odd that they appear at virtually the same time.. my bet is same class
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by pootle flump
    It does at least reassure me that there is enough ambiguity to not attempt an answer - my first reading was this is an implementation of a 7 level deep hierarchy.
    I'd agree its tinkering with list & combo boxes (perhaps not tinkering 101)
    I'd rather be riding on the Tiger 800 or the Norton

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Urgh - then the assignment would be something like "provide a rudimentary query builder for users". Yukkers
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    turn out my impressions were wrong, different countries
    I'd rather be riding on the Tiger 800 or the Norton

  12. #12
    Join Date
    Nov 2008
    Posts
    2
    The application is to log problems happen to a process. The log has to cover the following:
    - Location of the problem (Top most level table, parent to the next table)
    - Sublocation (child of location and parent to Equipment)
    - Equipment (parent to component)
    - Component (parent to part)
    - Part ...
    and so on it goes up to 7 levels (it might extend in future depending in business requirement)

  13. #13
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Have you considered using a tree control in place of the multitude of listboxes, especially if you are thinking of needign more than 7

    I'd also consider using two (poosibly 3) listboxes
    one shows current level data
    one shows current sublevel
    the optional other one shows what has been selected. if all you are after is one element of data I'd use a text box in place of the list box the 3rd listbox allows the option of adding and removing multiple items in your selection
    clicking on an item in the first list box chages the data shown in the 2nd list box.
    clicking on an item in the second list box does....
    wekl you need a mechanism to transfer the current m2nd list box selection to the fianl selcted item
    AND you alos need a mechanism to drop down a level (and whilst we are at it up a level


    the sort of interface problem is quite often resolved by usign a dialog similar to the column selection dialog in report designer, or perhaps slightly more relevant similar to the windows explorer.
    I'd rather be riding on the Tiger 800 or the Norton

  14. #14
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Is the design fixed? I've not had much coffee yet today so maybe I'm missing something - why is sub location a parent of Equipment and not an attribute? Perhaps it is just confusion over language but could you post your database design please?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  15. #15
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    could you post your database design please?
    This is what I'm waiting for....
    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

Posting Permissions

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