Data from form and subform to another table (1 Viewer)

[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

 

[Uncle Gizmo]

Do the records in the subform link to the record in the main form via an ID field?

 

[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.

 

[Uncle Gizmo]

Could you post the sample database just containing the forms and tables that you need help With.

 

[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