Copying text from 1 sub-form to another

Copying text from 1 sub-form to another

Hello,

Is it possible to copy text from 1 sub-form to another. For example:

I have a 4 forms

In the Drawings form I have a sub-form called Materials and the user adds as many material sizes as need.

Then in another form called Works_order the user selects the drawing number via a look-up linked to the Drawings form - then from that, can Zoho find all the materials in the Materials form and add them to another sub-form in the Works_order form?

I'm basically asking how to come all the "rows" from one sub-form to another really?

I hope this makes some sense

Thanks in advance
Ben