parent-child-grandchild realtionship question...

[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

 

[Marshall Barton]

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?

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.

 

[PC Datasheet]

Yes! In Access97 however that is as far as you can go. In later versions you
can go 10 deep.

 

[Brad Pears]

Anything special in the creation of this that I should be aware of or would
you configure as normal??

Thanks,

brad

 

[Marshall Barton]

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.