You can place as many sub-forms as you want.
the question is your relation you trying to display
For example
Employee shift ----> phone numbers
----> DownTime
----> scrap
----> name of children
The above has the employee shift as the "parent" table, and then each of the
other tables are related back to the employee shift.
however, you might have the following:
Employee shift ----> Downtime---> scrap
----> name of children
etc.
In the above, each employee shift has a downtime record, and each downtime
record can have many scrap records.
So, the first example is easy, as you can just create a sub-form, and drop
in as many sub-forms to display related data.
For the 2nd example, you have to use a sub-form within a sub -form. And, you
can't use contuse forms to display the data.
What I do in these cases is actually drop in two sub-forms in to the form
(but they are NOT nested).
There is a screen shot of this type of layout in the following:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
Look at the very last screen shot. You have a main record, then on left side
you have many, and for each of the many, you have many on the right side.
In the link child/master settings for child 1, you place:
linkChildFields main_id (whatever is the name of the field in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [ID]
In the link child/master settings for child 2 form you place
linkChildFields main_id (whatever is the name of the field in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [child1].[form].[ID] ("masterForm" is the name of
the contorl you used to hold the master form).
You likely have to put a requery command in the left side continues form's
"on current" event to make the right side update (but, try it as above..it
might work without having to even write one line of code).
