Use Another Table for Primary Key on Report

Content

Hi all,

I hope the below makes sense. I am trying to have a report run in our incident workspace that will show any other recent incidents raised recently under the same interested party contact.

The difficulty I am having is the report will always fill the c_id field from the incidents -> contact -> c_id
I need it to get the value from incidents -> interested_parties -> contacts2 -> c_id when the tab is opened and the report runs from the workspace.

I don't think the interested parties add in is standard across the OSC product, but it's a way of attaching other contacts to incidents whom it relates to. I have attached some screenshots. The first shows the report I have built, taking the contact ID from the incident contact. The second shows the interested party assigned to the incident whose contact ID i need to go into that field. I had to redact all my information but you can get what it is from the headers.