Many-to-many relationship between Locations and Companies

[maryvaughn1]

I understand that a Company can have multiple Locations.  But can a Location have multiple Companies?  We have client locations that are supported by multiple companies (local practices) within the enterprise company.  Does ServiceNow support this OOB?

[Satishkumar B · Accepted solution]

Hi @maryvaughn1 

ServiceNow supports many-to-many relationships through custom tables. To associate multiple Locations with multiple Companies, create a custom many-to-many table with reference fields to both `cmn_location` and `core_company`. Add related lists to the Location and Company forms to manage these associations, as this setup isn't available out-of-the-box.

……………………………………………………………………………………………………

Please Mark it helpful 👍and Accept Solution✔️!! If this helps you to understand. 

[maryvaughn1]

Thanks so much Tera.  This is very helpful