I have two forms in zoho creator Shipping and Product Info. Shipping Form has Bill To, Address, Ship To, Ship to Address and a auto number field id.
And in Product Info form we have "Product Id, description, qty, unit price and list price" fields.
Product Info form is subform in shipping form. I have to fill all the information in forms and on submit I have to display these fields in page.
When I submit the form then shipping Info is displaying fine from shipping view but I am not able to displaying all product info which I had inserted from product info view.
Please check the below mentioned code for the above mentioned problem.
<%for each SubForm r1 in Shipping [ID != 0]
{
productid = r1.Product_ID;
list_price = r1.List_Price;
Productdetails = r1.Productdetails;
qty = r1.Qty;
unit_price = r1.Unit_Price;
list_price = r1.List_Price;
productid = r1.Product_ID;
}%>
Also tell me is it possible in zoho creator to create relationship between two forms which are not related to each other?