Linking two fields on different tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-15-2017 10:56 PM
Hi All,
I have created new field 'Owner' on the Schedule Entry table.
I want to link this field with 'Owner' field on Events List [u_maintainance_blackout_change] table.
That means whatever I am selecting the owner in one table should reflect in the other table and vice versa.
Please advise on this.
Regards,
Nikita Khavnekar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-16-2017 03:23 AM
but then there will be two owner fields on event list table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-16-2017 03:37 AM
Remove the old owner field and use the dot walking field then if it is not ok you need to create 2 br's on the 2 tables.
To update the both fields on the 2 tbles.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-16-2017 03:40 AM
kalyan778 wrote:
Remove the old owner field and use the dot walking field then if it is not ok you need to create 2 br's on the 2 tables.
To update the both fields on the 2 tbles.
Although that's a valid approach, denormalising table structures goes against the "single system of record" concept ServiceNow employs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-16-2017 03:45 AM
please help me with the BR
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-16-2017 04:17 AM
See my earlier comment about reference fields.
You seem to be going about this in a very convoluted way when the results you see are achievable through much simpler (and recommended) methods. Avoid antipatterns where possible.