If you need to insert a record into a table where you have a foreign key that references a primary key that is not yet created, you can open a secondary form, insert the row that create the primary key and then submit the primary form and insert the initial record. I'm not good in English. Please try it and you will understand. Thank you.
To download the sample application click here Enjoy!