relationship and m2m tables

ginia dey1
Giga Contributor

hi all,

I wanted to know the difference between m2m table and relationship table since i am getting confused because both can be used to make related lists then what is the difference?

Thank you

5 REPLIES 5

Ujjawal Vishnoi
Mega Sage
Mega Sage

Hi Ginia,

Relationships:
Adding a Reference field on table A that points to table B, creates a relationship that ServiceNow can understand. This allows you to add a related list on records in table B, that displays the records from table A that are linked to it.

M2M table:Creating a M2M table via the sys_m2m relationship definition table also creates a relationship that ServiceNow can understand. Because of this, you can add a related list on either of the two tables linked by the relationship, to show related records from the other table.

Regrds

Ujjawal