We have a requirement to track Change Records back to the source INC and/or RITM records. A single change could address multiple INC and RITM records. Also, a single INC or RITM could be related to multiple changes (i.e. changes may be needed to multiple CMDB items to address an INC).
There is also a requirement to be able to report on all the INC and RITM records related to a change, and to report on all the CRs related to an individual INC or RITM .
Short of creating a custom table to store this many to many relationship, is there some OOB functionality we should be using? Is there a best practice for managing CRs and their related INC and RITM records we could look to implement?
