How to create a relationship between 2 related lists?

[Kiran_25]

I want to create a relationship between two related lists. 

On Change records there is a related list which displays all approvers for the record, including business owners. I have created a new related list which will only show the Business Owner approval for the CI item that the change request relates to. How can I achieve this? 

Or alternatively, is there a better way to achieve this outcome?

[Ankur Bawiskar · Accepted solution]

@Kiran_25 

you can create a new defined relationship.

Applies to Table - Change Request

Queries from - Approval

Script:

// get the approvers for this CHG

// get the CI for this CHG

// how are you determining the approver with CI?

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

[Kiran_25]

This worked, thanks! Do you know if there is a way i can display the impacted CI information in this related list too?

[Ankur Bawiskar]

@Kiran_25 

the related list shows Approvers then it can't show CI as the table is different.