Modelling many to many relationships with Entity reference, SearchKit, FormBuilder, ECK, etc.
Creating this issue as a way to keep track of different bits of functionality that can be used together to model many to many relationships in CiviCRM as when you put this all together, I think it is quite a game changer for data modelling in CiviCRM
Might make sense to document this at some point soon, and it would be good to collect feedback on how people are finding this functionality, ideas for improvement, etc.
Also, if you have any budget that you would like to put towards this work: to improve it or build out more features, etc. please get in contact with @colemanw or me
- Entity Reference fields - allows you to reference other entities in custom data fields effectively creating one to many relationships.
- Multivalue custom data sets - now available to all entities allowing you to model many to many relationships with additional meta data about the relationship
- Searchkit support for joining via EntityRef fields in multivalue custom data - allows you to create searches that span many to many joins
- FormBuilder support - allowing for editing of many to many relationships in entities (could probably do with some improvement)
- ECK which allows people to make arbitrary new entities that can be joined via these relationships