Best way to populate custom reference field on user table based on mapping from another custom table

[Sandro Pineda]

I have a custom reference field I added on the sys_user table that we will use to store Officer info for each employee. The plan is to use a custom table that houses mapping of which officer is associated with which department, etc. 

Should this be done as a business rule that updates whenever the department field changes on a user's record. That is essentially the catalyst to when that officer value could potentially change but perhaps there is another way to get it done. 

[Michael Jones -]

If the officer is tied to the department of the user, then a BR on the sys_user table that sets the officer based on the department, when department changes, makes logical sense to me and is the most straight forward and out of the box approach! I approve 🙂