How to capture parent record in related list of child record?

[Shraddha desai]

Hello, 

We have created M2M table to add related list in incident table that is "related incident".  when we are going to add related incident in related list "related incident" at that moment record are getting added but we open the added record from incident table our expected result is where we add this record its parent record number should be visible in its related list  i.e "related incident" but that is not working. How we can do that?

Is this possible by business rule?

from above picture we have added INC0000054 in INC0007001 indicident so our expected result is INC0007001 must be visible in related list of INC0000054 .

 M2M table-

Thank you!

[Mike_R]

I don't know the full requirements or business case, but this doesn't sound like a good idea.

Any reason not to use the OOTB parent/child Incident relationship?

[Slava Savitsky]

There is a contradiction in your design. By nature, parent-child is a one-to-many relationship whereas an m2m table represents a many-to-many relationship. In other words, you don't need an m2m table for a parent-child relationship. Use related list Child Incidents instead, which is available out of the box. Records added to that list get the field Parent populated automatically.

[Shraddha desai]

We have another created  custom table for the example I provide here incident table..

Is any solution for this?

[Slava Savitsky]

Parent is a reference field and can only contain a single record. However, by using an m2m table, you have the possibility to link any record to multiple other "parents". Obviously, multiple parents cannot fit into a simple reference field. When you use an m2m table, related records are always displayed as a related list, no matter which side of the relationship you are looking from.