I guess I'm intermediate - advanced.

Mostly for layout reasons  I have a form structure that is:
Main form, containing a tabbed layout with 3 subforms, with each tab / subform containing subforms.  The overall form is setup as a one-to-one relationship.  The Main form (parent) primary key is the master-child link to the subform (child) and then the sub-subforms (grandchild) link to the subform primary key with current records limits all around.  

Is that the right structure for the master-child linkage.  Should the grandchild reference the parent primary key directly?  They are really just a cascade.

My issue is that when I create a new record at the parent form level, it is not creating grandchild records.  The relationships are there, as are the master-child links.

---

Answer from Richard Rost:

I would have to see your database or at least know more about your table structures in order to tell you the best way to set it up.

However, when you have even a simple form/subform relationship, creating a PARENT record does not automatically create a CHILD record.

Take the instance of customers and orders. If you create a new customer record in the parent form, that doesn't not create an order record in the subform.

So your relationships and forms might be set up 100% correct. You just need to create those "grandchild" records yourself. Any kind of "do this automatically" is going to have to be programmed by YOU.