Conditional subform generation

[OZmc]

I am trying to generate a form that will have multiple sub forms conditionally based on how many observations need to be made.

Another way to think about it is this:
Let’s say I wanted to record information on individuals inside a household, across multiple households. The parent form would cycle through the various households. Here basic info that applied to all the residents would be recorded. Then depending on how many people lived in that house the proper number of sub forms would pop up to record individual observations that were unique each resident.

Is something like this possible? Or should I rethink my database organization? I imagine this is a complicated process and would appreciate just being pointed in the right direction.

Database organization:

Table of house info:
Table of individuals (linked to the “house” in which they live:
Table of things I want to record

 

[OZmc]

One way I was thinking of doing this was generating a form that at multiple subforms that were "hidden" and would only become visable based on the number of "residents"

is this a good way, or is there a better way to do this?