I have 2 forms

1) Inward

2) Stock Report

Both forms deluge code is under created or edited format.

When i enter the record and successfully submit the record data is mapped to Stock Report.

Following is the Code i am using

if(Inward_Type == "Fabric")
{
for each  rec in Fabric_Inward
{
duplicate_Record = insert into Fabric_Stock_Master
[
Added_User=zoho.loginuser
Design_No=rec.Design_No
Shade_No=rec.Shade_No
Meter=rec.Meter
Quality=rec.Quality
Width=rec.Width
Count_Construction=rec.Count_Construction
Weave=rec.Weave
Weight=rec.Weight
Content=rec.Content
Fabric_Type=rec.Fabric_Type
];
}
}
if(Inward_Type == "Shirts")
{
for each  rec_Shirts in Shirts_Inward
{
duplicate_rec_Shirts = insert into Shirts_Stock_Master
[
Added_User=zoho.loginuser
Design_No=rec_Shirts.Design_No
Shade_No=rec_Shirts.Shade_No
Size_S=rec_Shirts.Size_S
Size_M=rec_Shirts.Size_M
Size_L=rec_Shirts.Size_L
Size_XL=rec_Shirts.Size_XL
Size_XXL=rec_Shirts.Size_XXL
Size_3XL=rec_Shirts.Size_3XL
Size_4XL=rec_Shirts.Size_4XL
Size_5XL=rec_Shirts.Size_5XL
Size_6XL=rec_Shirts.Size_6XL
Total_Pcs=rec_Shirts.Total_Pcs
];
}
}
if(Inward_Type == "Accessories")
{
for each  rec_acc in Accessories_Inward
{
duplicate_acc = insert into Accessories_Stock
[
Added_User=zoho.loginuser
Item_Name=rec_acc.Item_Name
Item_Image=rec_acc.Item_Image
Narration=rec_acc.Narration
Quantity=rec_acc.Quantity
];
}
}
if(Inward_Type == "Trouser")
{
for each  rec_tr in Trouser_Inward
{
duplicate_tr = insert into Trouser_Stock
[
Added_User=zoho.loginuser
Design_No=rec_tr.Design_No
Shade_No=rec_tr.Shade_No
Size_28=rec_tr.Size_28
Size_30=rec_tr.Size_30
Size_32=rec_tr.Size_32
Size_34=rec_tr.SIze_34
Size_36=rec_tr.Size_36
Size_38=rec_tr.Size_38
Size_40=rec_tr.Size_40
Size_42=rec_tr.Size_42
Size_44=rec_tr.Size_44
Size_46=rec_tr.Size_46
Size_48=rec_tr.Size_48
Size_50=rec_tr.Size_50
Size_52=rec_tr.Size_52
Size_54=rec_tr.Size_54
Size_56=rec_tr.Size_56
Total_Pcs=rec_tr.Total_Pcs
];
}
}
if(Inward_Type == "Denim")
{
for each  rec_Denim in Denim_Inward
{
duplicate_denim = insert into Denim_Stock
[
Added_User=zoho.loginuser
Design_No=rec_Denim.Design_No
Shade_No=rec_Denim.Shade_No
Size_28=rec_Denim.Size_28
Size_30=rec_Denim.Size_30
Size_32=rec_Denim.Size_32
Size_34=rec_Denim.Size_34
Size_36=rec_Denim.Size_36
Size_38=rec_Denim.Size_38
Size_40=rec_Denim.Size_40
Size_42=rec_Denim.Size_42
Size_44=rec_Denim.Size_44
Size_46=rec_Denim.Size_46
Size_48=rec_Denim.Size_48
Size_50=rec_Denim.Size_50
Size_52=rec_Denim.Size_52
Size_54=rec_Denim.Size_54
Size_56=rec_Denim.Size_56
Total_Pcs=rec_Denim.Total_Pcs
];
}
}
if(Inward_Type == "Kids")
{
for each  rec_Kids in Kids_Inward
{
duplicate_Kids = insert into Kids_Stock
[
Added_User=zoho.loginuser
Design_No=rec_Kids.Design_No
Shade_No=rec_Kids.Shade_No
Years_2_3=rec_Kids.Years_2_3
Years_3_4=rec_Kids.Years_3_4
Years_5_6=rec_Kids.Years_5_6
Years_7_8=rec_Kids.Years_7_8
Years_8_9=rec_Kids.Years_8_9
Years_9_10=rec_Kids.Years_9_10
Years_11_12=rec_Kids.Years_11_12
Years_13_14=rec_Kids.Years_13_14
Total_Pcs=rec_Kids.Total_Pcs
];
}
}

Now the Problem is when i edit the entry and submit that particular entry it again maps the records in the stock entry, instead of updating the record it creates another entry.

Thanks & Regards.