2022 Developer Survey is open! Take survey.

Questions tagged [many-to-many]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 "...
user avatar
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. ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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-...
user avatar
  • 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)...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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), ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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'...
user avatar
  • 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 ...
user avatar
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. ...
user avatar