Hello, I have the following forms and subform:

Purchase Order Form

Subform X (items in packages)

Subform Y (Items)

Total

SubForm_X (items in packages)

PackagesNameX (lookup field from Packages_Form.PackageName_p)

Subform_Y (Items)

(*)Material_Y

(#)Unit_Y

(#)Price_Y

Quantity_Y

Subtotal_Y

————

Materials_Form

Material_M

(#)Unit_M

(#)Price_M

Packages_Form 

PackageName_p

Subform Z:

(*)Material_P

(#)Unit_P

Quantity_P

(*) Is a lookup field to Material_M in Materials_Form.

(#) Fetched from Materials_Form

What I am looking to do is auto populate the Subform Y (Items) based on the Subform X inputs, fetch the units and price, and if there are 2 of more equal materials, sum them. For example:

2. if(row.Material_Y != null)
3. {
4. row.Subtotal_Y=row.Price_Y * row.Quantity_Y;
5. }
6. x = 0.0;
7. if(row.Price_Y != null)
8. {
9. for each  rec in Subform_Y
10. {
11. x = x + rec.Subtotal_Y;
12. }
13. }
14. input.Total = x;