Append query with autonumber

[xolo]

How can I use append queries to add records into 2 tables (with 1 to many relationship and autonumber primary key on parent table)? The Autonumber is set to "Random" and the tables have already some records before.

 

[HiTechCoach]

I have not figured out a way with just append queries.

I find it best to use a recordset for the parent table and one append query for the related records.