I have an app which records family information in a Family table and uses reference fields to relate to a People table tracking which people are in which families. I want the user to be able to move a person from one family to another, but I’d like to throw up a warning/confirmation message if they edit the field which does this (the FamilyID field on the Person record).
The entry field would still be valid, so I can’t use the Error_Message_If_Invalid function. I want to at least throw up a warning message if they edit this field, and preferably have the user confirm that they intend to make this change before saving. Is there a way to do this?