For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hello,
A technique often recommended in the community for setting up many to many relationships is to create a cross reference custom object. When this occurs, say between the contacts object and the organizations object, when a contact is deleted, its relationships to the organizations should also be deleted. And when an organization is deleted, its relationships to contacts should be deleted. It is my understanding that for this to happen automatically, both relationships to the cross reference table would need to be an aggregation relationship. Is this acceptable? And will it work as I described?
Thanks,
Scott