We are looking to enforce certain workflow rules. For example, assume Al and Bob are Support, Cindy and Dave are Customer Service, and Eli and Francine are Business Analysts. The workflow is that Support can’t assign requests directly to Business Analysts without first going through Customer Service. Thus, Al can’t ever assign a request to Francine.
I think this can be done using Triggers (i.e., if Al tries to assign a Request to Francine, assign it back to Al), but would quickly become unwieldy because I would need a separate trigger for each combination of Assigner/Assignee/Category (the number of triggers might also affect performance). Is there some better way to accomplish this?