Questions tagged [junction-object]

In Salesforce, a Junction Object is a custom object with two master-detail relationships to two different record types. It is used to represent a many-to-many relationship in which several junction objects can link one instance of a record to many children, and each child can equally be linked to many parents.

Filter by
Sorted by
Tagged with
1
vote
1answer
35 views

Associate a Case with Multiple Locations

I need to give users the ability to create a case that's associated with multiple locations. There's currently a Master-Detail relationship between Account and Location. When a user is creating a case ...
0
votes
1answer
19 views

Using Junction object to display related list

Problem: I need to create a way to view two related fields on a given record between two different custom objects. I have looked up junction objects and it seems that this will be the best solution. ...
1
vote
2answers
95 views

Can you create a 3 way many to many relationship between objects?

I want to create a custom object called Groups. I then want to create a M2M Relationship between Groups and Accounts. Then I want to Create a M2M relationship between Groups and Contacts. Is there a ...
0
votes
1answer
27 views

Changing junction object name

I have an existing junction object that is named poorly and is causing a lot of confusion. I wish to change the name of this object and move the changes to production. Can you please let me know ...
-2
votes
1answer
29 views

How to display contacts as they relate to accounts on a custom object [closed]

I am a newbie in salesforce I have a custom object say X which has master detail relationship with Account. Now I want to display the list of contacts related to account under the custom object X. ...
0
votes
0answers
17 views

Filter picklist values based on other objects field values

Is it possible to filter picklist values based on the 2 other object fields relation? In that case I mean for example: I have an Order Type field which on junction object is related to Region (e.g. ...
0
votes
1answer
41 views

How can I map two queries from junction objects into an instance of a custom object class that I need to return?

I need my getUser method to return an instance of the custom object class UserCTI. I need make two queries and map their results into the UserCTI object, or I can make a subquery within the primary ...
0
votes
0answers
17 views

How can I return a Custom Object with a List of Parent Data from querying the Junction Object? [duplicate]

I am new to Apex trying to do some practice assignments and have gotten stuck on this junction object query. Task: Edit the current getUser() method to do the following: Return a custom object (that ...
3
votes
0answers
72 views

How to use sfdx force:data:tree:export to export CPQ Bundle Product for import into a new scratch org?

For starters I am trying to only export set of Products, Feature and Options that comprise a single bundle Product, but having problems because Product Option object has two lookup relationships to ...
0
votes
0answers
8 views

Can user group be used to create junction object?

I wanted to set up many-many relationship between projects and teams, and i would like to utilize the user group so that the user can only see the projects that are assigned to his/her group. But it ...
0
votes
1answer
30 views

is it possible to get the parents old value in trigger update on junction object

i have a issue in retrieving the old value of parents record onthe junction object update scenario, do anyone have come across this scenario, please throw lights. Junction__c oldlrj = [SELECT Id, ...
0
votes
0answers
66 views

How master-detail records are synchronized/accessible in junction object?

I have a Juction object CaseJiraItemAssociation__c which is have two master-detail relationship (on Case__c and JiraItem__c custom objects) and I have one outbound message (end point) on JiraItem__c ...
0
votes
0answers
84 views

Inserting record on Junction object with formula fields

I have Junction object called Agreement Scope which has two Master Detail relationships with Account and Agreement. We are assigning Account and Agreement in the lightning components Apex Controller ...
0
votes
2answers
57 views

Filter records using junction object using SOQL query

I have a many to many relationship with 3 objects Position, Candidate, Job Application(Junction Object). I wanted to retrieve all the positions applied by a particular candidate and also the positions ...
-1
votes
1answer
286 views

TRIGGER to update related records on Junction object

My scenario is One candidate can have a multiple Job application, custom objects are candidate__c(lookup to job application) Job_Openings__c(lookup to Job application) Job_Applications__c(junction ...
0
votes
1answer
43 views

Hide a Field in junction object

In Account Object, I have 2 different record type - type1 and type2. There is a Junction Object call Associated Location between Locations and Accounts and I want to hide a checkbox field in ...
2
votes
2answers
217 views

DML Insert List of Child Records and Junction Records in a single DML Statement

I've 3 Custom Objects (List) : List <C1> (Child) fields : Id, Name List <C2> (Child) fields : Id, Name List <C3> (Junction) fields : IdC1, IdC2, Name I was able to get C1 IDS ...
1
vote
1answer
358 views

Upsert in junction records without duplicate creation

Have a junction object that is a many to many relationship between two obejcts - Account and Publisher. As mentioned in the documentation I set the key in the Is there an easy way to upsert junction ...
1
vote
1answer
199 views

Many to Many Relationship on OpportunityLineItem, and similar Junction Objects.

I'm trying to add special characteristics that are not entirely products, so I thought, that the best way would be to make a many-many relationship between the Opportunity Line Products, Quote ...
0
votes
0answers
64 views

How to limit lookups in many-to-many relationship based on related record attributes?

I have created a many-to-many relation between Contact and Skill, a custom object that represents a contact's skills. A contact can be one of two different record types, Type A and Type B. I want to ...
1
vote
2answers
150 views

Querying to fetch data from junction object and Accounts

I have a junction object called "JIRA_Data" and its linked/ related to Accounts. How do I query to fetch data from this relationship. I am trying to extract id,type from Account object and Name from ...
0
votes
2answers
182 views

I need to update a checkbox on account object to true if there is at least 1 custom object picklist vaule selected

I need to update a checkbox on account object to true if there is at least 1 custom object picklist vaule selected, so even if the picklist value changes on related projects then the account checkbox ...
-2
votes
1answer
82 views

How to get parent field values based on linked junction object

I have 3 objects. Platform and documents are parent and junction platform is child. Platform Junction platform Doc (junction object) documents I need all the documents linked to the platform. For ...
1
vote
1answer
183 views

Incorrect Documentation - You can't create outbound messages for workflow rules on junction objects

In Workflow Considerations documentation, Workflow Limitations section, it has been specified that. You can't create outbound messages for workflow rules on junction objects. I have created a ...
-1
votes
1answer
149 views

Update Priority of Cases related to another Case through a Junction Object

We have a junction object called "Related_Development_Cases__c" that has 2 many-to-many relationships to the Case object through 2 Case lookup fields (Support_Case__c and Development_Case__c). We ...
0
votes
1answer
119 views

How do I automatically update fields on a custom object with information from Events?

and thank you all for taking the time to read my question! Here's what we're trying to accomplish: Automatically populate a "parent" object, Project, with information from an Event used to schedule ...
0
votes
1answer
406 views

Can a List View be made that filters on Junction Objects?

My organization associates Users with Contacts. We have a custom junction object to establish a many-to-many relationship between Users and Contacts. We want to allow Users to filter the Contact list ...
1
vote
1answer
104 views

Create related object of certain Record Type on Object [closed]

We are using the case object to different case type, due to that we have a lot of different record types. For a case it is possible to have a related Product this is done with a junction object. So ...
-2
votes
1answer
41 views

How to setup junction pointing 2x to contacts to delete child records when master is deleted?

The contacts in our SF instance can give gifts from other contacts or receive gifts from contacts. I need a way to represent who gave to whom and if a contact is deleted any record with the taker and ...
0
votes
1answer
39 views

How to setup giver and receivers with junction object

The contacts in our SF instance can give gifts from other contacts or receive gifts from contacts. I need a way to represent who gave to whom. Would the following scenario work? Create an object "...
-2
votes
2answers
534 views

How to implement Trigger on junction object to update field on contact

I have a junction object called contact_role__c between contact and a custom object called property__c. I need to update a field on contact object whenever a new property__c is created. This is what i ...
0
votes
0answers
369 views

Deleting junction objects

I have a use case where the Master object can only have one child object at a time, so when a user selects a new child object I need to delete the original junction object via Apex and create a new ...
1
vote
1answer
411 views

How to update contact object from related junction object?

I created a junction object called Sponsorship__c and have a many-to-many relationship. It is related to Contact through a master-detail relationship and I have another custom object called ...
1
vote
1answer
153 views

Junction Object between same SObject Type (b-directional siblings)

What is the best way to implement a Junction object that connects two of the same SObject Types? I have a data-structure that sort of represents a sibling relationship. Each Treatment__c has 0 or ...
1
vote
1answer
853 views

What is security access for child record when master is private

There is one junction object in which one master object has owd public access and one master object has private access
1
vote
0answers
255 views

SOQL / Apex To Find Duplicates On A Junction Object ( OpportunityContactRole )

I have a rogue trigger that inserts duplicate OpportunityContactRoles when it shouldn't. I can't find the error in my code, but it's not a high-volume problem. It is, however, a daily low-volume ...
0
votes
2answers
698 views

I cannot create child object to junction object

I have a junction object(JuncObj) with a custom object(ParentObj1) and contact as the masters. I've created a separate obj(NewChildObj) that is supposed to be a child object of JuncObj. When I create ...
1
vote
0answers
29 views

External Junction Object Rearchitecture

Currently we have a junction object between a standard object and a custom object. Our SOQL queries are pretty straight forward for example SELECT Id, Date, Contact__r.FirstName, Contact__r.LastName,...
0
votes
2answers
225 views

Need help in fetching the details using junction object

I have 3 objects Object 1 and Object 3 are Connected through a Junction Object Object 2 Obj1 Record Obj2 Record Obj3 Record Rate 1234 ...
2
votes
1answer
90 views

Uploading relationships between two objects linked with a junction object

I am setting up an insurance brokerage CRM where a Contact can have multiple Group Policies and a Group Policy can have multiple Contacts. I have these two objects linked with a junction object, ...
0
votes
1answer
490 views

Many to many relationship between Account and contract

Can we create Many to many relationship between Account and Contract? I have done this with junction object but i have one doubt as Contract have lookup relationship with Account which is required on ...
0
votes
1answer
496 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
215 views

Calculating the externalId field value using Dataloader CLI

I have a dataloader CLI process setup to import a csv file from a share folder. I am upserting to an object in Salesforce. This object is a junction object called employee training. The junction has ...
1
vote
2answers
105 views

SOQL from a junction record?

Hopefully this is simple to everyone with a bit more experience. I am trying to retrieve related records with a query. The objects are related via a Junction Object. I've done quite a bit of ...
0
votes
1answer
35 views

How to replicate Partners in Force.com app

I want to replicate part of the 'Partner" functionality in my app. I have accounts and I want to tie them to their lender. In this case Lender is a replacement for partner. I want the Lender ...
0
votes
1answer
210 views

How to retrieve data from Junction object for indirectly related object

Below I'm trying to explain how the objects are linked to each other and what needs to fetch from an indirectly related object. I want to update a field on Order object based on the value of a field ...
2
votes
0answers
29 views

Junction object field has weird name in WSDL

Lets say i have objects Event and Contact. Between these two objects i have created junction object. Checking WSDL whats the name of field on Event for this junction reference I find out, that it is ...
2
votes
2answers
121 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. ...
1
vote
2answers
185 views

is a SOQL subquery with a junction object possible? [closed]

I am trying to access Contact information from a Opportunity object across a OpportunityContactRole. Does SOQL support this?
0
votes
1answer
200 views

can't create many to many relationship between Account and Product

Product is not showing up in the object list when I am trying to create a master-detail relationship from my junction object. what's the workaround? Thanks