Button problem for new entries using one-to-many relationship

[Lunch]

I’m creating a new database that has layered amounts of data. What I’m trying to do is build it so that can enter mother/child information on the same page. Users can then click a button for each child that opens up a second form that allows users to enter as many studies as that child participated in as needed. The problem I’m having is when there hasn’t been an entry for the child there is nothing to match on so the childid won’t populate and the childid entry ends up blank. I know if I used some sort of nested forms or update queries I could work my way around this but there is a better way. Thoughts?

[llkhoutx]

You have 3 related tables Mother, Children and Studies, e.g.

tbMothers
PKMother
txtMother

tbChildren
PKChild
FKMother
txtChild

tbStudies
PKStudy
FKChild
txtStudy

tbMothers.PKMother is related 1 to many to tbChildren.FKMother
tbChildren.PKChild is related 1 to many to tbStudies.FKChild

Create theres relationaships if the Relationships window.

Display the data in a Mothers form (parent), with a children subform (child), the children subform has a subsub form Studies (grandchild).

Populate he forms in the following order parent, then child, then grandchild. If this order isn't utilized orphans without a preceding ancestor will be created.