multiuple parent child relationships....

[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

 

[Wayne Morgan]

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.

 

[Brad Pears]

Thanks, I'll give it a shot....

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.