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