create subform records from another suform

create subform records from another suform

hi,

My app has this forms:


Orders
Order details
Shippments
Invoices
Invoice details


Order details is a subform of Orders
Order details is also used as a maiform, wich has shippments as a subform.
Invoice details is a subform of Invoices.

Now I want to have a lookup field at shippments where i would chose an invoice (or create one if it doesn't exist). When i would chose the invoice, the shippment record data should be copied and create a new record at invoice details.
This records should be invoice details records (subform) that populate the invoice (mainform) choosed at shippments.

Is this possible? Any ideas?
Thanks!