Linking two fields on different tables

Nikita35
Kilo Guru

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

11 REPLIES 11

but then there will be two owner fields on event list table


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


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.


please help me with the BR


Dave Smith1
ServiceNow Employee
ServiceNow Employee

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.