Many-to-Many Relationship - Finite Partners (2023)

There are three ways to relate tables in ServiceNow. A one-to-one relationship would be used when a record from one table is related to one record in another table. An example of this would be in a school database, each student is assigned an ID and each ID is only assigned to one student. A one-to-many relationship is when one record in a table is related to many records in another table. For example, if we had a table of customers, each customer could be related to many sales orders. Finally, we can create a many-to-many relationship. A many-to-many relationship is when many records from one table are related to many records in another table. An example of this would be a customer can purchase many products and products can be purchased by many customers. I am going to show you in the steps below how to create a many-to-many table in ServiceNow.

1) First navigate to the m2m table. You can navigate to this table by typing “sys_m2m.list” in your left navigation filter.

Many-to-Many Relationship - Finite Partners (1)

2) Create a new Many-to-Many relationship table. Click the “New” button on the “sys_m2m.list” list to create a new record. The only fields you need to fill are the “From table”, “To table”, and “Many to Many table” fields. The other fields will automatically fill but can be changed if needed. I recommend filling the “Many to Many table” field with a unique name for your reference.

Many-to-Many Relationship - Finite Partners (2)
Many-to-Many Relationship - Finite Partners (3)

3) Add the related list to your table, in this example it is the “Products” table. Click on a record within the table. If there is not one, create it. Once you are in a record, right-click in the banner and navigate to Configure->Related Lists.

Many-to-Many Relationship - Finite Partners (4)

Next, highlight the table you would like to add and select the “>” to add the table.

Many-to-Many Relationship - Finite Partners (5)

Once you click “Save” you will be navigated back to the “Products” table. You should see the related list now.

Many-to-Many Relationship - Finite Partners (6)

4) Relate a record to test. At the bottom of the “Products” table, click “New” next to “Customers.”

Many-to-Many Relationship - Finite Partners (7)

After you submit the new record, you should see the record in the related list and the “Customers” table.

Many-to-Many Relationship - Finite Partners (8)
Many-to-Many Relationship - Finite Partners (9)

Now you have created a many-to-many relationship.

Top Articles
Latest Posts
Article information

Author: Catherine Tremblay

Last Updated: 06/09/2023

Views: 5749

Rating: 4.7 / 5 (47 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Catherine Tremblay

Birthday: 1999-09-23

Address: Suite 461 73643 Sherril Loaf, Dickinsonland, AZ 47941-2379

Phone: +2678139151039

Job: International Administration Supervisor

Hobby: Dowsing, Snowboarding, Rowing, Beekeeping, Calligraphy, Shooting, Air sports

Introduction: My name is Catherine Tremblay, I am a precious, perfect, tasty, enthusiastic, inexpensive, vast, kind person who loves writing and wants to share my knowledge and understanding with you.