I have an access backend with a 1:M parent-child relationship. I need to find a way to create a new record in Infopath.

Currently, I can only create a new record by "saving" the parent table, then "query" for that record saved, which then populates back into the parent table, so that I can finally enter data into my children tables.

My primary key is not bouncing back into the parent table.

I want to be able to enter data in the parent and children tables, then press "submit" to save (all in one step).