I have two picklists on Opportunity-Product standard object. Controlling picklist (Product_List_c) has all the products listed. The dependent picklist (Applications_c) has all the applications that the product is used for.
When I select the product from standard price list to be added under an Opportunity, the Product name is displayed with other fields to be entered manually.
I want to set or auto select the Product_List_c value to be the same as the product selected to be added in Opportunity so that only the relevant application list is shown to be selected.
I do not want to go for Visualforce page. Any other pointers are appreciated.
Regards,
Abhijeet.
2 réponses
Thanks Sindoora for the reply. However, I cannot go with URL hack method since there is already an existing process in place and I do not want to reinvent the wheel.
To give a more detailed picture; the current process is a normal process of adding products to Opportunity with a standard picklist having all the applications. This application picklist has all the applications related to all products. Currently there is no controlling or dependent picklist.
I am trying to create a new controlling picklist having products. The existing application picklist will then be made as a dependent picklist to products.
Now, the problem is if i select the product, how do i select and set the controlling picklist value same as the product name selected in normal opportunity-product process. Once this is achieved, the dependent picklist will automatically show only the relevant applications corresponding to this selected product.
WFR is also not possible because WFR executes only in case of any field updates while in this case, the product is just selected and not saved to opportunity.
I am fine with the code/trigger. If you can help with the code, that will be great.
Regards,
Abhijeet.