Scenario: I have a Visualforce Page on which users create Quote Line Items based on a custom search function. First, they select the product. Next, they fill in some values that come from a FieldSet, i.e. Sales Price. There is also a picklist on Quote Line Items that needs filled in, but the values of this picklist should be based on the Record Type of the selected product. In other words, the picklist on Quote Line Items should function like a dependent picklist across objects.
Question: What is the best way to make a "dependent picklist" across objects?
Suggested solution: I don't think it's possible to create a dependent picklist across these objects, so I have thought of the following solution. First, I create a new picklist on Quote Line Item holding the same values as the Product Record Type. Next, I set the value of this field in Apex and add it (as hidden field) to the VisualForce page where they fill in the fields for their new Quote Line Item. Lastly, I set my picklist up to be a dependent picklist based on this new picklist.
Is this the best solution for my problem, or are there better ways to do this?
Best Answer
I like you solution very much. It is simple, allow us to use standard functionality. Only thing missing for me is custom setting. There should be simple way that allow user decide what record type match what value of picklist. Such mapping will be easy to maintain and more flexible that direct assigning in the code.