Data import to multiple tables

[isladogs]

An immediate issue is that Table2 has no PK field.
Always use a PK field and that includes junction tables.

Not sure what normal duplicates means
You still need to protect against unwanted duplicates
e.g. caused by running the import sequence twice by mistake

Edit
I would get rid of the badly named multi valued field. Loads of trouble for little benefit.
Also rename 'memo' field as it's an Access datatype

 

[tmguru]

Doc Man & ridders, thanks so much for your suggestions! I will make some changes based on your suggestions!