multiuple parent child relationships....

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I currently have a form on which I have a parent shild relationship. ie..
the subform contains child records of the parent form. Now, I would like to
introduce yet another parent child relationship for the child form. So,
basically it would go like this. Each parent has multiple children( the
child form) and for each child, I need to have multiple children as well -
so we have a parent->child->grandchild relationship on the same form.

Is this doable in access and how?

Thanks,

Brad
 
Yes, it is doable. You would do it the same way you made the current
form/subform. Place the third form on the second as a subform and set the
Link Parent and Link Child relationships for the third form.
 
Thanks, I'll give it a shot....
Wayne Morgan said:
Yes, it is doable. You would do it the same way you made the current
form/subform. Place the third form on the second as a subform and set the
Link Parent and Link Child relationships for the third form.
Click to expand...
 
Back
Top