Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Many to many definition on same table

Go to solution
Christine30
Tera Guru

‎02-05-2024 03:03 PM

I know this question has been asked before but I couldn't find a solution. Is it possible to create a many to many definition on the same table?  When I try, I get the error "M2M from field and M2M to field must be different".  Changing the field names doesn't create a correct many to many table.  Thanks for any help with this.


Christine

0 Helpfuls
  • 2,007 Views
1 ACCEPTED SOLUTION

Go to solution
Christine30
Tera Guru
In response to AshishKM

‎02-09-2024 01:30 PM

Thank you.

 

I was eventually able to do this by creating a list field and related list relationship by following the steps here: https://www.servicenow.com/community/itsm-forum/many-to-many-on-same-table/m-p/440044

 

And then creating a database view using the list field by following the steps here: https://www.servicenow.com/community/developer-forum/database-view-with-list-field/m-p/2432202

View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
AshishKM
Kilo Patron
Kilo Patron
In response to Christine30

‎02-09-2024 01:40 PM

Good to know, you manager to get the desire result. 😎


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
0 Helpfuls