How to create Related List for Demands to Enhancements and vice versa?

[Kevin McGartlan]

Hello, 

I have a requirement to create a related list from the Demand and Enhancement forms to show any demands/enhancements related to each other. I have created a reference field on the demand form to the enhancement table, and also a demand reference field on the enhancement form. However, whenever I create a demand or enhancement by clicking the "new" button on the related list, the newly created record doesn't seem to be a "related record" when I navigate to the newly created records form. EX: I create a demand from the enhancement related list. I then navigate to the newly created demand, and I do not see the enhancement association in either the reference field, or the "demand" related list. 

Does anyone have an idea on how to accomplish this? 

Thank you! 

[Alikutty A]

Hello Kevin,

There is a one to many relationship already existing in the OOB structure. I guess you are using an incorrect related list which is OOB and hence they are not getting listed. If you need to manage many to many relationship then you should add a new entry in sys_m2m table instead of creating reference fields. Can you please follow these steps and see if it works for you.

1) Navigate to sys_m2m.list and create the entry below and click on Create Many to Many

2) Go to the Demand form and add the Enhancements related list on it.

3) Go to the Enhancement form and add the Demands related list on it.

Once these are added, you can now add or remove multiple enhancements on a demand and vice versa.

[Kevin McGartlan]

I tried to use the OOB related list for demands/enhancements. However, whenever I create a demand or enhancement, the newly created record (whether it's demand or an enhancement) doesn't show up in the corresponding related list. I've tried all the different related list, but still no luck. 

[prathamesh5]

I have the same requirement ! have you achieved this?

if yes, can you share please..