Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Family Tree (2003)

    How can I make it so you can see a family tree in access. Cow 5 had 06-5 two year later 06-5 had 08-06-5 How can I get a report that will show me that 5 is the grandma of 08-06-05. Please see attachment
    Attached Images Attached Images

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Family Tree (2003)

    Can you post a cut down version of your database for us to see.

    It is not clear what the two tables are (or even why there are two tables.)
    It is normal to have a self join for genealogy database, so that the father and mother of an individual are entries in the same table.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Family Tree (2003)

    This word attachment might be clearer
    Attached Files Attached Files

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Family Tree (2003)

    I am sorry but I don't understand why you have two tables : Cows and Transactions, both of which seem to be Cows.

    I am not a farmer, so when you talk about Replacement and Keeping Back, I don't know what you mean.

    I attach a very simple example showing a single table can refer to itself, and how a query can extract information for 3 generations.
    Attached Files Attached Files
    Regards
    John



  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Family Tree (2003)

    Sounds like you should be using a recursive table. With all your livestock in the one table but with two fields that points to its parent(s).

    When you write your report you can group on each Parent and have a sub report that finds all of its children.

    Does this sound like what you want? If so then you are welcome to ask for more detail.

Posting Permissions

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