I'm in the process of creating a ORDER and QUOTE forms. I have a list of my products and uploaded the same to my account in Zoho Creator. The problem I'm facing now is, I have 4 colunms in my product list (mentioned below)

1.   Category (with 3 category)

2.   Product Code (46 Codes)

3.   Product Name (46 Products)

4.   Unit Price  (46 price)

Now, when my customer select one from the drop down of " Category", the " Product Code" dorp down should show only the code associated with the selected category. Likewise when the " Product Code" is selected the " Product Name" & " Unit Price" should automatically populate in their row. 

So how do we do this. Please help me!

Thanks,

Nathan Ross

nathanross1987@gmail.com