On a case record I want to source a customer list/record field based on the only customers with specific partners. In other words, I want to display only customers who match the partners I specify. This is very dynamic, so I did the following thinking it would work.
1. Created a multi-select Partner field on the case record. This has some filtering on it that brings back specific partner records.
2. [Can't do this but want to] Create a list/record Customer field and set:
Source List: the multi-select Partner field
Source Filter By: Partner
3. On beforeload, I select all of the records in this multi-select field, so that the sourcing in #2 is activated and sources in all customers that have a partner selected in the multi-select field.
Problem is that Source List in #2 does not display the multi-select Partner field as a choice. If I change this multi-select to a list/record then it is available in the list. So, looks like I can't source from a multi-select.
Second option was to try a filtering line where I would select the Customer field 'Partner' and compare it to the multi-select field, but again, the multi-select Partner field does not show up in the 'Compare to Field' list, so can't source this way either to a multi-select field.
Bottom line is I want to be able to source a list against potentially more than one value, so a multi-select is the only option I can think of. Can this be done?
Would be really interested to hear other ideas on how to accomplish this. Deperately trying to solve due to the lack of filtering available on built-in customer list/record fields.
Thanks.