I have a order form with a subform.

The items are as follows:

・department(dropdown)

・name(dropdown)

---subform---

   ・date

   ・product name(lookup)

   ・name(single line)

----------------

The name field in subform is automatically entered the name selected in parent form by deluge when users input product name.(or, when users add row to subform.) 

And, name in subform is hidden field.

Now,  what I want to ask is

If the above is not possible,

2.Is it possible to clear product name field (or,input null) in all rows ?

   Or, is it possible to delete all rows ?

I was achieved to rewrite, clear, or input null  only single row, but I did not know the way to apply to "all rows".

 

i.e.

I want name in subform and name in parent form to have the same value when users click "submit".