Relationship Between 2 table

David Boom
Tera Contributor

I have one custom table with field "number". It is string type field and auto-populating with incident number. I want this table to be in related list of incident table. In related list only records with same incident number should be visible.

1 ACCEPTED SOLUTION

Chaitanya ILCR
Kilo Patron

Hi @David Boom 
You can create a custom relationship

applies to table = custom table where you want to add this related list

ChaitanyaILCR_0-1741087526576.png

once submitted configure the related list and find the relationship name in the slush bucket and add it 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

View solution in original post

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

@David Boom 

should be an easy task

Applies to table - incident

Queries from table - Custom table

Script

// u_number is the custom field on custom table

current.addQuery('u_number', parent.number);

Then configure the form -> related list and add this new one in your correct view

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@David Boom 

Hope you are doing good.

Did my reply answer your question?

As per new community feature you can mark multiple responses as correct.

If my response helped please mark it correct as well so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader