Questions tagged [many-to-many]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
2answers
303 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
106 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
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
263 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
470 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
61 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
259 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
43 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
53 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
703 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
914 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 ...
3
votes
2answers
179 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. ...