Hi Everyone,
We have a reference variable on a record producer which is referencing to the User table and we have MRVS on the same itself. We have written a script to update this MRVS to add groups based on the user selected.
For Example : If the user is part of three groups, then three rows will be added in the MRVS.
Now we need to make validation is such a way that :-
1. If user delete any row out of the three auto updated rows in the MRVS, then deletion should also reflect in the group membership table, Example- if the user is part of A,B,C and the rows are added in MRVS are also A,B,C, if I remove 'C' entry and submit the request, then user should be only in A,B but not in C.
2. If I make any update to the entries that are added to MRVS, same update should also reflect on the group membership table, Example- if I change the group name of 'A' to 'AB' the same update should also reflect on the group.
Please help me to get the validation script ASAP. Thanks in advance.
