To make two fields dependent

sidhu rs
Tera Contributor

Hi All,

I have created two fields in two different tables,
Ex: I have created group field that reference to 'sys_user_grmrmber' in Table 'A' and I created 'user' field that reference to sys_user in  Table 'B'. Now if I select group in Table 'A' the members in that group should be visible in user field lookup in Table 'B'.

Could anyone please guide me on this

 

Regards,

Sidhu.

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @sidhu rs 

 

Sorry but I did not get your point completely. What exactly you wan to achieve. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG ,

I have two reference fields in two different tables A,B, In Table A I have a assignment_group field is there. If i select database in assignment_group then, in Table B the database group memebers need to popluate in Assigned_to field.

 

Regards,

Sidhu 

Hi @sidhu rs 

 

It is OOTB. Have a look into Incident Assigned To:

https://INSTANCENMAE.service-now.com/now/nav/ui/classic/params/target/sys_dictionary.do%3Fsysparm_qu...

 

LearnNGrowAtul_0-1701430625853.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG ,

Here Both fields are in different tables not in same table.

 

Regards,

Sidhu.