I have two fields in PPMC on a project form:
1. Project Manager (allowing just one name)
2. Project Manager Replacement (allowing two names)
What I want to achieve is, when you enter a name in Project Manager, that name can not be entered in the field Project Manager Replacement and vice versa.
Any tips on how to achieve this?
Create a rule that does a SQL instr on the other field, if found set a specific value in a hidden field.
Create another rule that look at the hidden field value and acting on it, maybe a popup, reverting input or something