Questions tagged [many-to-many]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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. ...