Four-Level Form

[WayneRyan]

hi,

I am about to design a form that has a four-level Master-Child
relationship. I did this a few years ago.

My question is:

Should I have one main form and three subforms?

or

Should I have one main form with a subform, the subform has a subform,
and that subform has a subform?

Help
Wayne

 

[Pat Hartman]

When the relationship is hierarchial, you should use a subform within a subform within a main form. Access only allows three levels on a single form. Your fourth level can be a popup from the innermost subform.

 

[WayneRyan]

Thanks Pat,

The info helps. In a way it's good that the last level is
a popup. It will be used to assign people to a task and
will provide more room for the other levels.

I do remember that a previous implementation of this had
a main and three subforms. All of the linkage was done by
events with a lot of requeries. I think the screen kind of
flickered a bit when refreshing.

Thanks again,
Wayne