parent-child-grandchild realtionship question...

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

Brad Pears

We have an Access 2000 application that has a master form and a subform in a
1-many (parent-child)relationship. We now want to add an addtional subform
to this form. This new subform would be a subform of the subform already
present. So, in essence, we would have a parent-child-grandchild
relationship...

Is this possible in Access?


Thanks,

Brad
 
Brad said:
We have an Access 2000 application that has a master form and a subform in a
1-many (parent-child)relationship. We now want to add an addtional subform
to this form. This new subform would be a subform of the subform already
present. So, in essence, we would have a parent-child-grandchild
relationship...

Is this possible in Access?
Click to expand...


Sure it's possible (as long as the child subform is not
displayed in Continuous view). Prior to A2K a grandchild
for was as far as you could go. Since then you can have up
to seven levels of forms.
 
Yes! In Access97 however that is as far as you can go. In later versions you
can go 10 deep.
 
Anything special in the creation of this that I should be aware of or would
you configure as normal??

Thanks,

brad
 
Nothing special, except for the continuous (and datasheet)
form restriction. Do make sure that you have the Link
Master/Child properties the way you want.

Try a simple test example to get a feel for it.
 
Back
Top