Parent / Child Relationship - Viewing and editing - MS Access

I am working on the design of a database enhancement that will incorporate parent/child relationships.  I am looking to have the ability to have an ongoing string of Parent, Child, Grandchild, etc. I have two tables:

PEOPLE:  PersonID, Person
LINK: ParentID, ChildID

I have a query that links the parents to the children.  I've filled in some data below and also attached it as a screen.  As you can see.  Dave is a parent of Amy and Carrie.  Amy is a parent of Dylan and Colin, therefore Dave is a grandparent of Colin.  

One of the main things I am looking for is a way to display the relationships for the user to view.  If this could be done on a form, it would be preferable.  I have attached a screenshot of the "visual view" of the relationships that I would ideally like to see.  I have looked into the "treeview" ActiveX component, but could not get anywhere with that.  

Any assistance or ideas you could provide would be greatly appreciated.
Parent  | Child
Dave    | Amy
Dave    | Carrie
Amy     | Dylan
Amy     | Colin

Open in new window

Parent-Child-Query.jpg
Visual-View.jpg
LVL 1
cdmac2Asked:
Who is Participating?
 
noetymologyConnect With a Mentor Commented:
Since you want to display relationship of your data to your user, treeview control suits this requirement. Please find attached a sample database created using KB article http://support.microsoft.com/kb/209891 which is a simpler method. You will have to change the field names in the table/code. Open the form and expand Fuller by double clicking it. Hope this helps.
Parent-Child-.mdb
0
 
Luke ChungPresidentCommented:
In Access, you can use subdatasheets in your tables to go down one level, but I don't think it's recursive.
You'll need to use the Treeview control to do this but it'll require a bit of VBA coding to load it up.
0
 
Rey Obrero (Capricorn1)Commented:
see if this link helps
How To Use the ADO SHAPE Command
http://support.microsoft.com/kb/189657

0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
cdmac2Author Commented:
Thanks capricorn1... that ADO SHAPE command may work, but I cannot figure it out from the article (it's a little too technical for me).  Could you show me how to use the SHAPE command using my example data?
0
 
cdmac2Author Commented:
Just following up... Any suggestions??
0
 
cdmac2Author Commented:
That did it... thx noetymology!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.