Multiple connected subforms in one form or a suggested workaround

Multiple connected subforms in one form or a suggested workaround

I have several objects that are 1-many related objects in a kind of vertical hierarchy so for example Courses have several Units and Units have several Objectives and Objectives have several Criterias etc.

I would like to make it easy for the user to add this structure in one form since a lot of the information is common so no need to repeat the whole hierarchy again every time they want to add a Criteria for example.

I created a Add Course form which allows adding Units (as a subform):


I was also trying to allow him to add the Objectives in the same form since Objectives are a subform of the "Units" form which is added as a subform to this main form. Basically Objectives was a subform of the subform but it does not look like this is possible.

Since I am new to Zoho Creator I was wondering if any of you experts had any suggestions to tackle this problem.

Can I add two sibling subforms and use Deluge to connect between the two? But if so, how do I "select" a record in a subform so that I can connect the other subform to it? Subforms seems to only have "input" fields not like a record where you can "select".

Should I be using Pages/Reports instead? How do I connect the different parts in a Page so that when I select a "record" on one part I show the list of child records on another part? And can I add new records and have them immediately appear in the same screen?

Any help would be greatly appreciated