We have a SFM to let our engineers debrief their Work Order. In this transaction we use a lookup field to Activity Master. In the Activity Master we set up a lot of activities with a Product Family (Multi-Select Picklist). This means an action is applicable for 1 or multiple Product Families.
Now in the SFM I would like to limit the activities the engineer can choose, based on the Product Family of that Work Order. e.g. if the product family of the Work Order is "Laptop", I want the lookup screen to show all Activities that have "Laptop" chosen in the Multi-Select Picklist. Currently this functionality only works when the Activity Master record has only 1 value for Product Family, but I want it to work whenever one of the values selected is "Laptop".
Hopefully its clear! If not, let me know and I can try to explain further.
What is the underlying problem do you intend to solve with this idea?
Avoid creating duplicate records for different familiesImprove system maintenance/development
How is the problem being addressed today, if at all?