Replicate the "Group Members(sys_user_grmember.group)" related list on Group form for a custom table

[Mudabir]

I have a custom table ( Custom 1) with two reference fields 
1. Group field ( Reference to Group table)

2. Issue  field ( Reference to a different custom table (Custom 2))

On the Group form I want to show a Related List that shows the records from Custom 1 table ( which is pretty straight forward)
I want "Edit" button on this related list. But when the "Edit" button is pressed, on the left side of the slush bucket it should show records from Custom 2 table. Just like for ""Group Members" related list, this related list shows user records on the left side of slush bucket when "Edit" is pressed.

Thanks!

[JenniferRah]

There's a special process for creating a true M2M table. Check the documentation here: https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/table-administ...

[Mudabir]

It is not working. I created a M2M relation b/w Group & Custom 1. Upon pressing "Edit" , on left side it shows records from Custom 1 table! I wanted it to show records from Custom 2 table.

[raj chavan]

-use an M2M Table Correctly

Instead of a direct M2M between Group (sys_user_group) and Custom 1, create an M2M table between Group and Custom 2.

This ensures that when the Edit button is clicked, the left side of the slush bucket displays records from Custom 2.

- Modify the Related List Configuration

Navigate to sys_relationship (System Definition > Relationships).

Find the existing relationship for Group → Custom 1.

Modify the “Use Slushbucket” option and set the Related List M2M Table to your M2M (Group - Custom 2) table.

- Ensure the Correct M2M Table is Used in UI Action

Go to UI Actions for the related list.

Check the sys_relationship used and ensure it’s pointing to Group - Custom 2.

[Mudabir]

Hello @raj chavan 

I think only scripted Relations are present in sys_relationship table because I do not see the automatically created relationship for Group-Custom 1 in that table. Moreover, there is no option "Use Slushbucket" there
Thanks