Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2015
    Posts
    3

    Access 2013 Show Family Relationships

    Hello everyone, I am trying to create a database for my church and one of the features requested is that the database show family relationships of our church members. For instance if you were to pull up an entry for an individual in our church it should show who that person's Spouse and Children are. I'm a little confused as to how to actually implement this in an Access database. I would appreciate a push in the right direction. Thanks in advance!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    This is not an easy db to build, especially if you want to track multiple generations - children can also be parents. Have you searcehed for family tree db?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Further to June's comment, here is a link to a site with several data models. This specific one is for Genealogy.
    And I will second the previous comment -- hierarchies are not a simple subject or database.

    Good luck with your project.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Then you have the issue of blended families (divorce, remarriage).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-08-2015, 12:41 AM
  2. Replies: 1
    Last Post: 12-15-2014, 07:20 PM
  3. Outlook 2013 + Access 2013 + HTML
    By Yann63 in forum Programming
    Replies: 2
    Last Post: 11-26-2013, 02:39 PM
  4. Replies: 18
    Last Post: 06-19-2013, 10:58 AM
  5. show table relationships
    By jassie in forum Access
    Replies: 1
    Last Post: 03-26-2012, 03:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums