sql insert - Create New record in multiple tables Access 2013 -

I want to create a new record in multiple tables. Firstly, I want to make a record in person , then I want to use the personen_ID to create a foreign key in all other tables. These tables are linked to the primary key in the person table, and each gegevens is a foreign key in the table.

I have these tables:

Is this also possible? To create rows in the other table, you can use the [Personality] table after inserting:

< P>