I have trainee records that reference mentor records. In the trainee record, when I fill in who the mentor will be (it’s a ref field), I’d like the referenced mentor record to have an automatic change to one of its fields (I have an enum “status” field that I’d like to change to “active”). Is this possible, and if so, how is it done? It needs to not interfere with user agency to later change the mentor’s status manually. Thanks!
This post will have some details and techniques that will help you: