Need to build an relationship between RITM table and rm_story table

[Suseela Peddise]

We have a 'Requested Items' related list in rm_story table to show which RITM has been associated to that particular story .

Similar way , we wanted to see the linked stories in RITM level. For that I have created a new relationship between 'sc_req_item' and 'rm_story' table.

It is showing linked stories correctly in the related list, however default filter condition just showing as 'Stories' . There is no default filter condition available.

If I try opening the link in new tab, instead of showing only the linked story it is showing all the list of stories. 

Looking forward for the reply . Thanks in Advance.

[Mark Stanger]

It sounds like what you really want is a many-to-many table to store this relationship.  That will allow you to have one request item with a list of stories at the bottom and one story with a list of request items at the bottom.  Here is how you can create a many-to-many relationship table.

Here's an article showing how this should be done.

https://www.servicenowguru.com/system-definition/relationships/creating-manytomany-relationship-serv...

[Mark Stanger]

Just checking on on this one.  Has this question been answered or is there more information I can help you with?  If it's been answered, please mark the answer above as the correct one so people know this has been taken care of.  Thanks!