A many-to-many relationship consists of three objects: Object A and Object B are the two primary objects, and Object J is the junction that enables the many to many.
Object A <--M/D-- Object J --M/D--> Object B
So on Object J you need to create two Master-Detail relationships, one that points to Object A and one that points to Object B.
A many-to-many relationship uses one object to link two other objects together in limitless combinations. There are two types of these combinations, those that are unique (each pair of records can only be linked once, which actually has a limit of the product of each object involved), and those that are non-unique (each pair of records might be linked more than once).
For example, banks have many accounts, and people may have many accounts (even at the same bank), so each account a person has at a bank is a many-to-many relationship; the account itself (in database terminology) is the many-to-many object that ties the bank and the person together into a relationship, and describes their available funds, transaction history, etc.
As salesforce#1 stated, there are many examples of many-to-many relationships in salesforce.com:
Each object contains two or three "primary" relationships that link those objects together, just as bank accounts link banks to people, and contains relevant information, such as the two items involved (e.g. an opportunity and each product price associated to it), and other relevant information (e.g. the quantity being sold and the discount given).
Hi,
A many-to-many relationship consists of three objects: Object A and Object B are the two primary objects, and Object J is the junction that enables the many to many.
Object A <--M/D-- Object J --M/D--> Object B
So on Object J you need to create two Master-Detail relationships, one that points to Object A and one that points to Object B.
Go through the below links for the same :-
https://ap1.salesforce.com/help/doc/en/relationships_manytomany.htm
Hi
In salesforce many to many relationship exmples are
1)case and solution
2)campaign and lead
If this helps you, please mark this as solution so that it would be useful for others.
regards.
For example, banks have many accounts, and people may have many accounts (even at the same bank), so each account a person has at a bank is a many-to-many relationship; the account itself (in database terminology) is the many-to-many object that ties the bank and the person together into a relationship, and describes their available funds, transaction history, etc.
As salesforce#1 stated, there are many examples of many-to-many relationships in salesforce.com:
* PricebookEntry
* CampaignMember
* AccountContactRole
* Partner
* OpportunityContactRole
* CaseSolution
* OpportunityLineItem
* Asset
Each object contains two or three "primary" relationships that link those objects together, just as bank accounts link banks to people, and contains relevant information, such as the two items involved (e.g. an opportunity and each product price associated to it), and other relevant information (e.g. the quantity being sold and the discount given).