Use relationships to associate an object with other objects in Salesforce.

learn more… | top users | synonyms

0
votes
1answer
25 views

Relationship query - child that fetches its parent with all its children

I have a custom object rstk__poline__c that has a child yo parent relationship to rstk__sylocid__c. The parent object (rstk__sylocid__c) also has a parent to child relationship with rstk__sylocnum__c. ...
1
vote
1answer
17 views

Parent account field determine child account field values

I have a custom text area on Accounts called Geographic_Locations__c. In this text area, I list various US cities, each on their own line. What I am looking to do is to have each line of text ...
1
vote
2answers
25 views

Relationship problem and 'Illegal Filter on Attachment'

I have a query like this: SELECT ParentId FROM Attachment WHERE Parent.Type = 'Contact' When testing with an account, I get an error saying: [MalformedQueryFault [ApiQueryFault [ApiFault ...
4
votes
2answers
75 views

Is it possible to convert a Master-Detail relationship to a Lookup?

I'm going through the Trailhead training (here), and see the following two snippets which seem to disagree: "It’s possible to change a lookup relationship to a master-detail relationship, but ...
0
votes
1answer
21 views

How do I determine the relationships between custom objects?

Sorry if this has been addressed before, but I could not find a thread that was asking this. Background: I have limited OO programming experience in VB, Java, Python, etc. I am a Super User on ...
1
vote
1answer
14 views

UI approach for linking child records from the parent view page

Imagine an app using Account and Contact records. Both can life without another, but on Contact there is a lookup to Account. If you want to link a Contact to an existing Account using Salesforce.com ...
1
vote
1answer
32 views

Data Relationships, Data Filters and Automation Studio

I've created a User-Initiated Email that is using a Data Filter. That Data Filter is using a Data Relationship. When I try to fire an email send via Automation Studio, the job sits there running for ...
1
vote
2answers
97 views

Error: Didn't understand relationship 'Contract__r' in field path

So I have read other responses to the error like mines but nothing seems to fix the issue maybe someone can look at my code and help. I have in my controller class (trying to do an add and delete ...
0
votes
2answers
43 views

Relationship queries (parent-child)

I am new to Salesforce and I am struggling to get my head around the correct SOQL which correctly reference multiple tables. Some background: I have a custom field in Order Product called Teacher_c ...
1
vote
1answer
51 views

Workflow Creates Tasks not Related to any Records

I am the admin of an Org that I created a workflow for. The workflow is designed to create Follow Up tasks for the Sales users. I am getting a bunch (not all) of the tasks that have no record ...
0
votes
0answers
18 views

Master detail filter on transaction object based on M-D relation of master data

I have two custom object having Master detail relationship. These objects contain master data in my org Say Challenges and Actions. Here Challenges is master and Actions is detail object. Now i have ...
0
votes
1answer
31 views

Variable does not exist in relationship SOQL

I tried the following SOQL and tried to use the ProductCode but getting the error as given below. for(PriceBookEntry pbe: [Select p.UseStandardPrice, p.UnitPrice, p.ProductCode, p.Product2Id, ...
1
vote
1answer
29 views

Single query: fetch non empty folders

I'd like to know if it is possible to write a single SOQL query to pull all the Document Folders (I need only folder id) which are not empty.
0
votes
1answer
46 views

Display all the records instead of related record in a visual force page

I have a custom object as " gmod__Opportunity_Forecast__c " it has a look up relation with "product" object and api name is give as "gmod__Product__c". 1)Im querying on "gmod__Opportunity_Forecast__c ...
0
votes
1answer
46 views

Opportunity product and Quoteline item have the same behaviour

Can any one let me know .Opportunity has relatinship to opportunity product and quote object .Do opportunity product and quoteline item are related or do their have same behaviour or if different what ...
0
votes
1answer
38 views

Walking relationships in email templates in a workflow

I have a custom email address field on Account called Primary Email Address. We have also created a custom object off of account called Purchases. I want to be able to send an email to the Primary ...
5
votes
4answers
419 views

Mandatory child record when creating parent record

The standard object Account has a master-detail relationship with a child object called Address__c. In the Address__c object we store the various addresses an account might have. My question is as ...
0
votes
0answers
33 views

Get a list of territory names and assigned rule names

In this child-to-parent relationship query, I am trying to show the territory rule name (MasterLabel) from the RuleTerritory2Association child object: select ...
0
votes
0answers
15 views

Running query on two levels of parents and resulting column is not showing up (no error!)

I'm running a child-to-parent query in Workforce such as this person did - Child-to-Parent Query - [object Object] is the result. However (in Workforce) I am not getting an error, the resulting column ...
1
vote
1answer
71 views

How to create relationship between Custom object and Contact Object using SOAP API C#

I have created a custom object in Salesforce named Call_c. There is already a standard object in Salesforce named Contact There is a field named call_number_c__c in my Call_c and MobilePhone field ...
2
votes
1answer
101 views

Invalid Foreign Key Relationship when retrieving from class

I've a parent object (Product) and a child (Inventory). I'm trying to retrieve the value of the child object from a class that I've created. public class DisplayProducts { private Product__c ...
0
votes
1answer
38 views

How can I to take a child object from a parent and add it to a list?

Sorry that this is such a basic question, but i could not find out how to do this, I do not want to create a query, which is what most of the solutions i find on the internet are. Example: ...
1
vote
1answer
25 views

Best way to handle relationships to objects I cannot create look ups for?

I have an object and it needs to have a 1 - many reference to the Data Category used in knowledge base. We have a requirement to be able to configure which data categories show up on a given page. ...
0
votes
1answer
16 views

how to get Activity associated with a contact?

i want to get activities associated with a Contact..how it can be done..as per my knowledge there is no any relationship between activity and contact..so how can i acheive this please do reply Thanks ...
2
votes
1answer
21 views

How can I present display-friendly relationships?

I am creating an order management system in Salesforce. I have created a custom object called MyProducts which has the following fields: MyProductId (An autonumber field - MP-0001) Product Name ...
3
votes
1answer
31 views

Are SObjectField tokens safe in cross-managed package calls?

We have some code and SObjects and fields in a managed package that works when executed by other calls in that managed package as your would expect. The code looks like this. private SObjectField ...
2
votes
0answers
97 views

Visual Workflow: fast lookup with cross object criteria

I've created a visual work flow that has a fast lookup. The lookup basically finds the Account_Share records that have a parent account id equal to a variable. I'd like to take this a step further ...
0
votes
0answers
28 views

Query for a child's parent's child's child

Here's my question. I am trying to grab information on my child's parent's child's child. However i am not sure of the best way to go about doing this. Does anyone have any advise. In sort I'm ...
-1
votes
2answers
96 views

Best way to query child, grandchild from parent

What is best way to display child, grandchild from parent or more than 1 level SOQL down. I tried to display grandchild of a parent record. Any reference would be great. Thanks
0
votes
1answer
28 views

Subquery returns parsing error

I am trying to fetch the currently logged in (customer portal) users details from their related contact field via SOQL. I have created what I believe is the correct SOQL statement however I am ...
0
votes
1answer
38 views

Relationship objects from the current object

I have 3 objects A, B and C. And B and C have lookup to A. I want to find all the objects which have lookup to the object A. I am able to get all the Child Relationships (using ...
2
votes
1answer
83 views

How to find object relations with the schema builder?

If I have 5 objects that are interrelated. How do i find their relationship (parent to child or child to parent) using the schema builder ? As of now i can see the relationship chart only if i know ...
0
votes
2answers
58 views

GetChildRelationships not finding contact lookups for custom object

I have a custom object with many custom fields. Some of these fields are lookups to contacts. I have a visualforce page on which I need to list all contact fields for this custom object. I am using ...
1
vote
1answer
70 views

Get Contact info and CampaignMember status in one query

Is there a way to retrieve contact information (first name, last name) and campaign member status for all members of a campaign in one SOQL query? I know you can get just the contact information with: ...
1
vote
2answers
300 views

Is it possible to have more than 2 many-to-many relationships on an object?

Since we are limited to two master-detail relationships on any given record, is it possible to have more than 2 many-to-many relationships for a given object? This seems like a rather large ...
2
votes
0answers
176 views

Using a Lookup Relationship in a Formula Field

I want to update a field on the the account object based on a field being updated on the contact object, in this case a date / time field. So far, I have setup a lookup relaionship field on the ...
2
votes
2answers
708 views

What is wrong with my relationship?

I'm trying to use SOQL 'relationships' between two tables. I follow this example and it works fine: SELECT Account.Name, (SELECT Contact.Name FROM contacts) FROM Account from: ...
0
votes
1answer
121 views

Error: Invalid field Job_Application__r for SObject Position__c

I have two custom objects those are position and job application objects,those are related by lookup relationship.But when try to access the job applications through relationship I m getting above ...
0
votes
4answers
368 views

How To Retrieve the Related List Data?

I have a Object called SiteContracts__c and it has a Related List Object is Engineer_CheckList__c", now I want to get the Engineer_CheckList__c record which is related to SiteContracts__c how can I ...
1
vote
1answer
81 views

Relationship should be given to Opportunity or Product

I have created a custom object as CustomlineItem and wanted to give a lookup relation to opportunityline item .So i should create the lookup relationship with opportunity or product ( ...
0
votes
0answers
71 views

custom object Lookup relation should be given to OpportunitylineItem or opportunity product

I have created a custom object as OpportunitylineItem and wanted to give a lookup relation with standard opportunityline item .So now i should create with the opportunity product or standard ...
1
vote
1answer
70 views

What is the Relationship b/w Opportunity products and opportunity Line Item

can any one help me out .What is the relation ship b/w Opportunity Products and Opportunity Line Item.Are their same or different in their behaviour.Any help is very much appreciated.
2
votes
1answer
342 views

Updating a field in one object with the value from another a field in another object

I have searched and tried come up with a solution but I just can seem to do it. I am new to APEX in SF and what I thought was going to be simple I just can't seem to get to work. I want to update a ...
0
votes
0answers
54 views

Relating additional objects to my custom report type

I have created a new report type which links Process Instance and Process Report Node together so I can view approvals on my Opportunties in my report. This method works, however only the Opportunity ...
2
votes
1answer
245 views

SOQL Relationship Query : Compare Child and Parent field value in WHERE clause

Is it possible to compare the Child and Parent field values in a Single SOQL Relationship Query ? say get me all contacts for an account which doesn't have same name as its parent account. SELECT ...
1
vote
1answer
202 views

How do I restrict the ability of a user to edit and delete an object, but allow them to be edited via another object?

How do I prevent a user from being able to edit and delete records directly in an object, but not through a master-detail relationship that is related to the same object? For example, We have 3 ...
2
votes
1answer
149 views

Junction object confusion

I have 3 objects order, order_lines and shipment_lines . So order has many order lines and many shipment_lines. So I want to display order_lines and shipment_lines fields on a single related list on ...
3
votes
1answer
43 views

External SalesForce Forms

Is it possible to create external SalesForce Forms that can populate fields in the same way as inside salesforce? We offer online teaching and the idea is that teachers, after every lesson, can fill ...
3
votes
1answer
52 views

Mandatory to create Junction object?

I have attached a screenshot of the schema. I have order, order_lines and shipment_lines related as in the following picture... Is it mandatory to create a junction object to get shipment lines for ...
1
vote
2answers
65 views

Tally the number of items in a related lists on a related object

Hi guys I am a complete n00b with SalesForce.com, so please forgive me if my question is too basic, but I have been trying for about 2 days now and I feel like I am getting nowhere I have a database ...