Questions tagged [many-to-many]
The many-to-many tag has no usage guidance.
14
questions
1
vote
1
answer
113
views
Can an Account object have a lookup to another Account?
I need a way for the Account object to track Partners (which should also be an Account record). In a traditional relational database I'd model this by making a many-to-many relationship with a "...
- 125
0
votes
0
answers
27
views
Trigger to create a 2nd record on Junction object after creating an initial record on a related Account
I have created a junction object (Account_Relation__c) to be able to link accounts to other accounts (many too many relationships).
To do so, I made 2 lookup fields to accounts on the junction object.
...
- 59
4
votes
2
answers
575
views
How to avoid duplicate look up combination in many to many relationship?
I am trying to learn many to many relationships for salesforce objects, I was able to implement it using a junction object where there are two master-detail relationships. But it causes a duplicate ...
- 127
0
votes
2
answers
239
views
Is there a standard way to add junction objects to a parent using the parent's default record edit form?
I have Cases objects in my Salesforce instance, along with Recommendation objects. For each case I would like to have multiple Recommendations. The Recommendations are not unique to the case, so the ...
- 1,151
0
votes
2
answers
46
views
How to display a many-to-many relationship associated with the current user?
I have Cases, which have many Users assigned to them, and Users can belong to many Cases. This association is stored in a custom joining object called a UserAssignment.
I'm trying to find an out-of-...
- 1,151
0
votes
2
answers
305
views
SOQL salesforce Junction Object
I have got a requirement where i have created 3 custom objects.
Obj1 : Project, Obj2 : Employee
Obj3 : Assignment - This is Junction Object ( Master-Detail relationship to both Project and Employee)...
- 355
13
votes
1
answer
526
views
Counting each record's Nth degree of mutual or directional edges in a (many to many) graphical network of < 50,000 rows/nodes
Summary
I have created a many-to-many network graph relationship (social network). A Person can have many Friends. A Friend can be a friend to many Persons. Full object model (ERD) is given at the ...
- 1,080
0
votes
1
answer
70
views
How to access all the related lists of a custom object in visualforce email template
I want to access all the related lists in Attendee__c. Also, Attendee__c and Event__c are connected by a junction object called EventAttendee (many-to-many) relationship, I want to print out all the ...
- 11
0
votes
0
answers
275
views
How to manage sharing rules in apex?
I am currently learning Salesforce. And I`ve got the task on courses about apex managed sharing rules. I need to use 3 standard objects - Account, Contact, User and 3 custom - Terr(as a territory), ...
- 193
0
votes
2
answers
45
views
Import Contacts and related records together
Our schema is structured so that Contacts (alumni) can be linked to multiple Accounts (schools) using a custom object, which itself contains a few other fields. We also have other custom objects with ...
- 111
1
vote
2
answers
59
views
Many-to-Many schema design
We are soon to implement a solution where people (Person__c) can delegate jobs to other people, and which jobs depend upon a person's Role. (Role__c). The role of a person depends on the delegation ...
- 611
0
votes
1
answer
770
views
Best practices on many-to-many relationships
I'm working on a project where we have to import data from a client's old system and it does not quite match the schema of the objects we're choosing in Salesforce.
One example is that the table we'...
- 10.6k
0
votes
1
answer
1k
views
Lookup Filter on Junction Object referencing ID Field
I have a Master-Detail Relationship From an Object Flat to an Object Expense and also from Flat to an Object Housemate. Furthermore Expense and Housemate have a Many-To-Many Relationship through ...
- 648
3
votes
2
answers
235
views
Query to Include Child Junction Records - Didn't Understand Relationship
I have a Junction object name AcctContactAff which creates a many-to-many relationship between Contacts and Accounts and stores (among other things) the title of the person at the account.
...
- 131