how to build relationship between interaction and incident table while I have created incident through UI Action from Interaction.

[Community Alums]

Hi @Ankur Bawiskar 

I have two tables one is interaction and second is incident and there is OOB UI Action Create incident in interaction table.

I have created one related list in interaction and I want list of incidents which are created with specific interactions.

So I have build one relationship as below

Will you please help me?

[Anil Lande]

Hi,

I believe there is no reference or string field storing sys_id of incident/interaction on any of these tables.

There is no way to build relationship using OOB relationship.

To achieve this use case create one reference field on incident table which is refereeing to interaction table and update the UI Action part to associate interaction with incident. When you create any reference field it will create OOB relationship and you can add it as related list.

To associate interaction you need to update 'Create incident' Ui Action like below:

Here u_interaction is reference field on incident referring to interaction table.

Thanks,

Anil Lande

[Ankur Bawiskar]

Hi,

As mentioned you Anil if there is no field then you need to create and then link those

Regards
Ankur

[Laveena-Agarwal]

Hi @Community Alums 

No need to establish the relationship, there is table which stores this information - interaction_related_record, it stores all the task relationship with interactions.

If my response is helpful, please let me know by selecting "Accept as Solution" and marking it as "Helpful."

Regards,

Laveena