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
0
votes
1answer
25 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
27 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
16 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
39 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
56 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
64 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
82 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
56 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
272 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
42 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
199 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
333 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
181 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
131 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
153 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
81 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
169 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
141 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
106 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
376 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
93 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
520 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
354 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
385 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
150 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
826 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
247 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
672 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
212 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
89 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
468 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
488 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
210 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
102 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
206 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
183 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
197 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
2
votes
0answers
59 views

Updating Foreign Keys in a Master Detail Relationship on a Junction Object

I've created a custom object called CampaignQuote that has a master-detail relationship with Campaigns and Quotes/Orders. In this use case Quotes/Orders are used in the same way opportunities would be ...
0
votes
2answers
120 views

Question regarding validation rules

I have a junction object(volunteer hour) between volunteer job(custom) and contact(standard). whenever i try to save a record in volunteer hour, system triggers a validation rule of volunteer job. is ...
0
votes
2answers
63 views

Help required in building formula for validation rule

I have 3 objects Contact(standard), Volunteer job(custom) and Volunteer hour(custom). Volunteer hour is a junction between contact and Volunteer job. Contact has a custom picklist field 'status'. my ...