Join a table to itself

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • barbarao
    New Member
    • Apr 2013
    • 82

    #16
    Thanks. It is a hard loss for me as he was also my best friend throughout our lives.

    Entity Susan, for example, who is owned by Entity Caesar, may have 4 guides as well. Entity Blake who is owned by Entity Susan, may have the same guides, different guides, or no guides at all. Entity Caesar, and all the other Entities like that one who are at the top of their family tree are not owned by another Entity nor do they have guides.

    Entity Trevor may be self owned and have no or many guides.

    I need to report not only on the full family tree but also generate reports on each type of guide.

    Ownerships do not change often if at all.

    I read through your article many times and sketched it out and just can't see how it will save time in building the solution or running any reports but I will read it again. Perhaps this time it will dawn on me but till then, I am going to keep the depth field in mind as a potential answer.

    As usual, thanks for your help and suggestions. You have always come through for me on this site.

    Comment

    Working...