Many Many Relationship table in Related Links

[anirban300]

Hello All,

I have created a newCI-Location relationship table where there are two fields 

1. Application Field (From Table "cmdb_ci")

2. Location Field (From Table "cmn_location")

I have also created a many to many to many relationship table between the tables "cmdb_ci" and "cmn_location". Now I want to add this relationship table in the related list of 'cmdb_ci' table but I am not getting the many to many table. Can someone help me in this?

Regards

Anirban

[Amit Gujarathi]

Hi @anirban300 ,
I trust you are doing fine.

I understand that you have created a new table for the CI-Location relationship with fields from the "cmdb_ci" and "cmn_location" tables, and have also created a many-to-many relationship table between these two tables. However, you are having trouble adding this relationship table to the related list of the "cmdb_ci" table.

To add the many-to-many relationship table to the related list of the "cmdb_ci" table, you will need to follow these steps:

1. Navigate to the "cmdb_ci" table and open the related list that you want to add the many-to-many relationship table to.

2. Click on the gear icon at the top right corner of the related list and select "Configure" from the dropdown menu.

3. In the "Configure Related List" window, click on the "Add" button and select "New" from the dropdown menu.

4. In the "New Related List" window, enter a name for the related list and select the "Many to Many Relationship" option from the "Type" dropdown menu.

5. In the "Related List Definition" section, select the many-to-many relationship table that you have created from the "Table" dropdown menu.

6. Select the fields that you want to display in the related list and click on "Save".

You should now be able to see the many-to-many relationship table in the related list of the "cmdb_ci" table.