Validate data from fields of one table with the data from another table and apply condition
I have a table itcchgautoassignment with which the itc.chgautoassignment form is associated. The form has fields like division, category, subcategory, type, subtype, Workflow and Change Coordinator.
Depending on the combination (Division, Category, Subcategory, type and subtype) , the workflow and the assignment is defined in the form and is saved in the database. Good so far.
Now the logic is, whenever an user raises a new change, by selecting the combination of (Division,Category,Subcategory,type and subtype) , the combination selected in cm3r would search for the combination in itcchgautoassignment, and if it matches then the defined workflow will trigger and the Change coordinator group will also be assigned automatically.
Any guess on how do I acheive this? Or any better plans if you guys can come up with. Would really appreciate it.