Many-to-Many Relationships Related Lists

dharanidd
Kilo Contributor

Hi All,

I have added the related list in change request form by creating many-to-many relationships. But ITIL users cannot able to view New/Edit button.

Any solution?

Thanks,

Dharani

1 ACCEPTED SOLUTION

shloke04
Kilo Patron

Hi,



The Table which you have created and added it as a Related List on your form won't be accessible to ITIL Users by default.Once the Many to Many Relationship Table has been created, you need to configure a Create, Read & Write Operation ACL on your M2M Table both on Table and Field Level to have the New & Edit button displayed on your Related List.



While configuring the ACL, Mention the "itil" Role in your ACL.



For example, below is the screen shots of an Create Operation ACL on Table and Field Level. Similarly you can create for the Operations mentioned above:



find_real_file.png



find_real_file.png



In the above screen shots Replace your Table Name just and similarly Configure the same for other Operations Like Read & Write.




Hope this helps.Mark the answer as correct/helpful based on impact.



Regards,


Shloke


Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

View solution in original post

4 REPLIES 4

shloke04
Kilo Patron

Hi,



The Table which you have created and added it as a Related List on your form won't be accessible to ITIL Users by default.Once the Many to Many Relationship Table has been created, you need to configure a Create, Read & Write Operation ACL on your M2M Table both on Table and Field Level to have the New & Edit button displayed on your Related List.



While configuring the ACL, Mention the "itil" Role in your ACL.



For example, below is the screen shots of an Create Operation ACL on Table and Field Level. Similarly you can create for the Operations mentioned above:



find_real_file.png



find_real_file.png



In the above screen shots Replace your Table Name just and similarly Configure the same for other Operations Like Read & Write.




Hope this helps.Mark the answer as correct/helpful based on impact.



Regards,


Shloke


Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

This is working awesome




Thanks a lot


Venkateswarlu K
Mega Guru

HI Dharani



can u pls follow procedure



How to personalize a related list so the New and Edit buttons appear:


  1. Open the form containing the related list to update. In the example, the Incident form is used.
  2. Right-click the header bar of the related list and select Personalize > List Control. In the example, the Task SLAs related list is used.
    new_edit_buttons.png
  3. On the List Control form, the Omit new button and Omit edit button option are selected by default. Clear these two options.
    new_edit_buttons1.png
  4. When the Omit new button and Omit edit button options are cleared, the New roles and Edit roles options appear.
    new_edit_buttons2.png
  5. [Optional] Select specific roles that can use the buttons. Click the lock icon next to New roles or Edit roles and move roles from the Available column to the Selected column.
    new_edit_buttons3.png
  6. Click Update.
  7. On the parent form, check that the New and Edit buttons appear in the related list.


Step 3 is the spot that can be confusing. If you select the Omit new button and Omit edit button, the buttons do not appear on the related list.   If you want the buttons to appear and you want to control the roles that can use the buttons, be sure to clear the Omit new button and Omit edit button options.




I hope this will helpful to u


Sadasiva Reddy
Giga Guru

Hi,

 

Can you please help me with how you have created/ acheived M2M relationship. because i saw in some other posts mentiuoned just creating record in sys_m2m table is enough to acheive it. but i could not achieve it by doing the same. 

 

THanks in advance

 

regards,

Sadasiva