I have an app where I am storing a specific activity. Attached to that activity (using a subform) is any hazard that is found while doing the activity (1:n). So it's a one to many relationship between activity and hazard. Once those are stored, later we are doing some evaluation of each hazard. I need to store multiple evaluations against a hazard (1:n).

So, it looks like:

Activity 1 - (using a FORM)

    Hazard A - (using a SUBFORM)

         Evaluation x - (using ????)

         Evaluation y

    Hazard B

    Hazard C

        Evaluation z

Activity 2

Activity 3

     Hazard D

        Evaluation v

From what I can tell and have tried, it is not possible within Creator to put a subform in another form that is used as a subform. Has anyone run into this scenario and how did you get around the limitations?

Thanks.