Data from form and subform to another table

[REDaughdril]

I have a form with a sub form. I would like to have a button that would combine the data from the sub form with data from the main form to another different table.

I can do it but it just over writes the data.

I know will be simple but I haven't figured it out.

Like being unable to spell a three letter word.

Thanks

 

[REDaughdril]

No, it is a separate table.
Yes, it can just depends. I can, I just need the form and sub form to make a different table.

 

[REDaughdril]

how about a better explaination

Main form has a "Mission Number"

Sub form has "Unit Number"

New table would have the "Mission Number" and "Unit Number"

I need to assign multi unit to each "Mission Number"

Thanks