Adding Subform row when adding new row in deluge
I am still new to deluge, but I have have trouble locating information on this.
I have an online order form for my website. I would like to have a button to move that record information my main order form. I created a button in that report view of the online order form, and it does create the record in my main order form, brings the customers information over, but I am having difficulties adding a subform row.
I have tried to break it down as simply as I know how to, but it will not add the subform row.
Customer = Customers[Phone_Number == Phone];
if(Fuel_Type == "#2 Fuel Oil")
{
fuel = "4259390000000999120";
}
else
{
fuel = "4259390000000999172";
}
if(Phone == Customer.Phone_Number)
{
row1 = Deliveries.Products();
row1.Line_Products=fuel;
rows = Collection();
rows.insert(row1);
New = insert into Deliveries
[
Added_User=zoho.loginuser
Customers=Customer.ID
Status="Ordered"
Products=rows
];
}
Thank you in advanced for any help.