How to link two different tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2017 02:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2017 04:40 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2017 04:48 AM
Testify!