Form1

Form2

Form3

Form4

Form2 contains a 1 to many relationship with Form1

example...

in form2 I have UNIT A, which contains multiple Items from Form1

so UNIT A may have ITEM 1, ITEM 2 and ITEM 3, all with different quantities

I want to be able to select UNIT A in Form3 and have it create an individual record in Form4 (I think thats what i want to do) 

for each Item in UNIT A 

Thanks