How many Cascaded one-to-many Relationship can be accommodated in one access FORM

[Awaleed]

Dear All,

Im seeking help, in the following issue... I'm totally new in access, please ignore if I'm fail to explain my question.



I want to make a Master form which has many subforms, All the sub forms are related to each other with one to many relationships.
I tried to build but failed.
I tried builtin wizard which only take 3 forms, mean one master two slave, I want to put more then 2 subforms which are related to each other by one-to-many relation.

If some one need more explanation please ask.

[June7]

I think the limit is 7 nested forms. Only the last form can be in datasheet view.

How did your attempt fail, what went wrong - error message, wrong results, nothing happens?

What do you not understand about manually building form/subform arrangement? Do you know what a Subform Container control is?

[Micron]

Awaleed, I think you show a picture of table relationships (absolute max - 32 per table) created by the relationship builder. If I am correct this has nothing to do with the number of subforms or subreports (7) you can have on a main form.

June: or is this a relationship builder between form and sub forms, something I'm not familiar with since I don't use version 2013?
Thanks.

[June7]

It is image of Relationships window. OP just trying to show the hierarchy of table relationships upon which wants to base form/subforms.