Show Relationship between records in same database

Posted on 2007-10-19
Last Modified: 2013-11-27
I want to show a relationship in Microsoft Access made database.  I am making a Member Profile Database.
What I want is this:  When I enter profiles: for instance Me and my daughter.  One field is labled Child's Name and I will put my daughters name in there. Done, then I will enter my Daughters profile and another field will be labled "Parent", there is where I put my name.  At the end, I want to be able to open my profile and be able to click in the Child's Name field and it will bring up my daughters profile and then I can clik in the "Parents" field and it will come back to me.  Can this be done in Microsoft Access?  I am just learning about access and building databases.
Question by:griffinct
    LVL 4

    Accepted Solution

    Yes of course. You should set up all profiles in the same table but not store any relationship details in here.

    The thing I would do is to the have a 3 column table called linked profiles or something. The columns would be ID 1 > ID 2 > Type.

    So in your example if your profile is 1 and your daughters is 30:

    ID 1 > ID 2 > Type
    1        30      Parent
    30       1       Child

    As the relationship is 2 way you would need 2 entries to complete this properly.
    This table could per represented as a sub form on your profile form and a you could write an event that take you to another profile when you click on the ID 2 box of the sub form.

    Hope this helpos
    LVL 4

    Expert Comment

    This will accomodate those with more than one relationship (more than 1 child/parent) and many kinds of relationships could be siblings/aunt/grandparent etc

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now