Multiple Parent Record for Single Child Record

[happyG]

I have a Requirement in which I need to add multiple SRs as child into SIR, i did it by adding related list, but i am facing the if I added SR{1,2,3} to SIR A or after that i added SR{1} to SIR B then SR1 is removed from SIR A, 

The requirment is to keep the SR added in A&B SIR.

Summary :i have requirement in which we need a functionality to add a single SR as an child for multiple SIR how we can perform it

[PreetK]

@J Siva what if we set alert for the SR Record if thats already belongs to a SIR, i hv the same requirement can you explain how we can add this functionality.

[reshmakore57046]

Hello,

Use a Custom Many-to-Many (M2M) Table

1. Create a custom many-to-many relationship table (e.g., x_sir_srs_relationship) with fields:

   • SIR (reference to Incident or your SIR table)

   • SR (reference to Service Request)

2. Add related lists on both SIR and SR forms to show the mapping records from this M2M table.

3. Use UI Actions or custom logic to allow linking multiple SRs to one SIR and vice versa.

This way, SR1 can be linked to both SIR-A and SIR-B, and you won't be restricted by the native parent field.

Regards,

Reshma Kore.