2 Replies Latest reply on Mar 23, 2013 12:00 PM by LaRetta

    What's the Best Way to Navigate Between Many Parent/Child Generations?


      My current table has 17 tables in 3 majjor chains of parent / child relationships. Each of these 3 major chains have 5 generations of relationships. For example:


      Client related to 0, 1, or many Projects

      Project related to 0, 1, or many Deliverables

      Deliverables related to 0, 1, 0r many ProjectItems

      ProjectItems related to 0, 1, many OutsideCosts


      On the layout for each generation I have a portal to the child (except for OutsideCosts which has no children). I find it frustrating to drill down from the top to near the bottom of the chain of relationships to access great grandchild records. It's easy for a user to get lost. It would be great to have an interface that lets the user see at one time, and navigate through, the records in multiple generations of relationships. Has anybody already come up with an elegant solution to this problem?