Recordset as alternative to append query

[Randix]

Ok, I'm confused. I have a parent file and 6 child tables, they all are related with enforced integrity, etc. They have a common field on which the primary key exists. I'm creating a new record in the parent in a form, and then after i update but before I close, I'm trying to use recordset to create a new record in the child tables, but each time I try i get the message that the primary key can't contain a null value--it's the primary key that I'm trying to insert, so sort of a catch-22. So exactly how do i create a new blank record in each of the child tables when i create one in the parent? I have the same problem when i try and use an append query.

 

[llkhoutx]

The primary key is for the parent, each child has a foreign key (not a primary key)which may have duplicates or may be unique.