Perhaps you could help.
Microsoft Dynamics CRM 2015 “on premise” question.
I have a Case entity which has, among other things, a many to one relationship with Users, Categories and Areas.
Essentially I want to assign a particular Case record to a particular User depending on the Category and the Area selected thereon.
To this end I created a configuration entity called Assignments which holds the mappings e.g.
Litter, Dublin, John Butler
Graffiti, Belfast, Laura Garcia
Water pollution, Galway, Joe Smith
The Assignments entity has therefore "many to one" relationships with Categories, Users and Areas.
To update the Case entity with the appropriate user in Transact SQL would be a straightforward matter but how to achieve the same in a workflow, or how to approach it has me baffled.
I also have installed a “AGUtilities Distribute one to many” plugin if this is of any use.
Any help would be great.