Questions tagged [many-to-many]
The many-to-many tag has no usage guidance.
13
questions
3
votes
2answers
107 views
How to avoid duplicate look up combination in many to many realtionship?
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 ...
0
votes
1answer
38 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 ...
0
votes
0answers
15 views
Create a Master table from two many to many tables
For reports purposes, I would like to create a master table relating two custom object Opportunities and Product (many to many relationships) that are linked through a Junction Table ProdOpp
My ...
0
votes
2answers
29 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-...
0
votes
2answers
231 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)...
13
votes
1answer
432 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 ...
0
votes
1answer
51 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 ...
0
votes
0answers
243 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), ...
0
votes
2answers
40 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 ...
1
vote
2answers
51 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 ...
0
votes
1answer
647 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'...
0
votes
1answer
791 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 ...
2
votes
2answers
149 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.
...
