How to link two different tables

Raviteja K
Tera Expert

Hi All

I need to link two tables one is sys_user and one custom table based on few fields from sys_user tables.

When values in the sys_user gets updated same should be reflected in custom table.

How to achieve this, via a business rule?

Thanks in advance

6 REPLIES 6

we are trying to write a code to fetch unique values from a field for example division and populate those fields in the custom table.


Then your design is wrong.   If you want to relate them, use a reference field then determine some way of populating the reference.



Using a business rule to mirror data between two fields conflicts with ServiceNow's "Single System Of Record" concept.   It doesn't mean it can't be used (or done), just that it's not considered good practice because denormalised tables carry an additional maintenance overhead.


Testify!


 snl saturday night live church taraji p henson praise GIF