Need to show incident number on Change Request related list

[Arjun Reddy Yer]

Can anyone help me in getting out from the issue as when the User selects multiple Change Requests under Change Request Related List on incident Form then when the User open that particular Change Request then on Change Request Form under Incident fixed by Change Related List incident number must be visible. 

Same as when the User selects multiple incidents under Incidents Fixed By Change on Change Request Form then when the User open that particular Incident then on Incident Form under Change Request Related List change request number must be visible. @Vasantharajan N @Ankur Bawiskar @Anil Lande @Sandeep Rajput @Prince Arora @Ahmmed Ali 

Incident Form:

Change Form:

[Ahmmed Ali]

Hello @Arjun Reddy Yer 

The relationship in change request form "Incidents fixed by change" is build with the field "change request" on the incident form. So if you add any incident in that related list, the change number will be updated in the incident's change request field.

It is one-to-many relationship, means one change can solve multiple incidents, but one incident can have only one change request. You can still see the change request in the change request field.

I do not see the use case where multiple change requests are created from one incident.

The screenshot you provided for incident form is showing the related list based on parent field, which is not same as incident solved by change in change request form.

Thank you,

Ali

[Arjun Reddy Yer]

As in the incident form under Related Records removed Change Request field as mentioned in below screen shot.

But in the Change Request Related List as for 1 incident can add multiple change request right as when the incident is raised for solving the incident can raise multiple change requests right as mentioned in the screen shot

but if I open the change request that particular incident is visible under Incident fixed by Change as mentioned in below screen shot

[Ahmmed Ali]

Yes, that is because in incident form related list, if you see the condition in related list, it says "Parent = current_incident", which means when you are adding multiple changes to incident, you are updating parent field of those change requests with current incident. You can verify this by going to any of added change request and check the value of parent field.

Here this is one to one relationship as parent field of change request can be updated with one record only. So that related list will show all the change requests with parent updated as current incident.

Same is happening with your change request form "Incidents fixed by changes". Here it is one-to-many relationship. means you can update only one change request value in change request field of incident, but you can update same change request number in multiple incidents. Same happens when you add multiple incidents in the change request related list "Incidents fixed by changes" using edit button, it updates those incident's change request field with current change request.

You are looking at two different one-to-many relationship. These cannot work as many to many relationship. You will need to build that custom with M2M table.

[Arjun Reddy Yer]

Can you please help me in building that custom M2M table as I tried but unable to get that