Hi all,

I'm facing the following situation: 

In our Zoho CRM, I have a custom module, lets call it "ModuleC", with a lookup field related to Sales Orders module. When the user select a Sales Order in the lookup field, I would like to "populate" another lookup field (for now related to the Products module) with the Items from the "Ordered Items" subform from the Sales Orders module. In my idea, it would "filter" the Products in the lookup field, so the user only can select a product that is part of the Ordered Item from lookup field "Sales Orders". 

I hope my question is clear... :)

Thanks for your help!