Many to many definition on same table

Christine30 · ‎02-05-2024

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

Christine30 · ‎02-09-2024

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

AshishKM · ‎02-09-2024

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