This type of relationship links two objects together. Lookup relationships are similar to master-detail relationships, except they do not support sharing or roll-up summary fields.

learn more… | top users | synonyms

1
vote
0answers
18 views

Display related fields based on change to lookup

This is a simplified example of the problem I'm having, using minimum data. I've created 2 objects, branch and leaf. Each leaf has a lookup to branch. I put a button on the leaf list to create a ...
2
votes
1answer
31 views

How to use soql queries on multiple look up relationship object to retrieve specific data

I have 4 custom objects (as shown in the schema diagram). And they are associated using a lookup relationship. Now the objective of my question is to retrieve Product profile(product) for a given ...
0
votes
1answer
12 views

Lookup field from Case to Order doesn't detect any Order

I have created a simple lookup field from Case to Order. No lookup filter criterias are implicated so far. I have created two orders in database, and when I try to attach this Case to one of those ...
1
vote
2answers
26 views

Insert data to custom object with relationship using external Id

Good day everyone, I have installed an npsp package and then I created a visual force that will save a new affiliation . I've tried to used an external Id to save the data. I've already tried saving ...
0
votes
1answer
27 views

How to get the custom fields from a custom object

I have an object Event_Booking__c. I want to get all the fields from that object which is related to the Event__c object through Event_ID__c lookup. Any idea on how to do this?
1
vote
2answers
26 views

Auto Update Child Relation

Suppose I have an Appointment Object, which has Date, Specialization (picklist), and Patient(Master object-record type of standard object, Contact) I have another object, Visit, which also have the ...
1
vote
0answers
47 views

Lookup Field on Custom Object related to Activity (Task) (aka create a related list on Activities/Tasks)

This question seems to have been also asked here: Tasks and events custom related list with no resolution. I have the ZenKraft Shipmate UPS package installed in my organization, and I'm looking to ...
0
votes
1answer
35 views

Lookup function within an email referencing two Data Extensions

I have subscribers going into one data extension giving a value for a column. For example: data extension name "Foodie" column name "FoodID" with a number in that field, i.e. 1234. I have another ...
0
votes
2answers
25 views

Apply filter for lookup on custom page

I need to customize lookup for custom object (fetch records applying some filter) on custom page. What we have. Object ClientItem that contains object Operator. [ClientItem.Operator] Controller ...
3
votes
2answers
40 views

Lookup field on VF page do not populate values

I have this registration form (VF Page) that creates a contact up on submission. Contact have a lookup field mypartner__c which looks up mypartner__c custom object. User should be able to select ...
0
votes
1answer
19 views

Create a field base on the lookup field data

Good day everyone, Suppose I have an object "SAMPLE_OBJECT__c" which has a lookup field to "Accounts" object and it also has a another field which is "Value__c". Now what I want to accomplished is ...
1
vote
1answer
18 views

Showing custom object fields in page layout containing a lookup

I have a custom object called "Branche" which contains a number and a description field. My Account page layout contains a lookup field to this custom object. Currently, it shows just the number. How ...
0
votes
1answer
29 views

Populating a Field with Lookup to User ID

I have a date field that, when changed, I'd like for an update to another field specifying which Salesforce User made that change. Would the best way to go about this be a Workflow Field Update? How ...
1
vote
0answers
26 views

Error while updating custom object lookup using external id using SOAP API request

I am trying to update a Custom object lookup using SOAP API by passing an external Id. While doing that I am getting an error Invalid foreign key relationship name Service_Maintenance_Contract__r ...
1
vote
1answer
17 views

Flow Designer Visual Flow Loop Help

Goal: I'm trying to populate a look-up field on the lead object based on a text field on the the same object. I need to find the ID of the account object whose account name contains the text in the ...
0
votes
2answers
50 views

Automatically map Account Look up field on Lead in Salesforce

I have created a custom account look up field on the lead object. I want to attach leads to existing accounts based on the company name. So lets say if a lead comes-in and has filled out 'Salesforce' ...
1
vote
2answers
44 views

Can't Pass Through Value of Lookup Field on Insert

I'm having trouble passing through the value of a Lookup field on Insert. I've got an object called ts2__Project_Job__c, which has a custom Lookup field called Candidate__c which looks at the Contact ...
1
vote
1answer
48 views

How to update a lookup field with the value from a formula or text field?

I am not a developer and I do not yet write Apex code very well. I need an Apex Trigger to do the following: If field "A" is null, update this field with the value from another field "B" Field "A" ...
1
vote
1answer
20 views

Lookup fields appear with the Lookup button on record edit pages

Lookup fields appear with the Lookup button on record edit pages How can i make it in my VF Page ?
1
vote
1answer
47 views

Update Lookup(Campaign) Lead value via trigger

I have a Lookup(Campaign) field Consumer_Newsletter__c set up on the Lead object. The Lookup(Campaign) field populates the Campaign Name on the Lead record. I'm trying to put together Apex code ...
0
votes
0answers
8 views

Searchable Fields in lookup research window

when i click on a look-up, in research window, i check 'all fields' but when i enter the name of the account (for example), it search this Account.name only in the email field, is there a way to set ...
1
vote
1answer
32 views

Customize result of of lookup field search

Can I customize result of a lookup field search? For example, I want to see only the contact related with an account. This account is selected by another lookup. Only way that I find is to flag the ...
2
votes
1answer
51 views

Update parent object on child object update/insert

I have opportunities that are linked by a related lookup to contacts. I would like a field on the contact to list all unique "program types" on opportunities. Thus, when an opportunity is updated or ...
3
votes
0answers
45 views

Save & New Button for Visualforce page with data on lookup

public class ProductController { ApexPages.standardController m_sc = null; public ProductController(ApexPages.StandardController sc) { m_sc = sc; } public Pagereference ...
3
votes
3answers
105 views

Lookup field value through query is gibberish?

I have a custom object (Team_Assignments__c) with a lookup relation (Team_Member__c) that references the User object. Team_Member__c should be the name of a user. However, my SOQL query for the ...
0
votes
2answers
59 views

SOQL: I need to display a Visualforce list of cases where each row can be expanded to display indirectly related cases

So there are 3 case records types: A, B, and C. A and C cases both have lookups to B cases, but otherwise have no direct relationship. I need to display a VF list of A cases where each row can be ...
4
votes
1answer
66 views

Salesforce URL Hacking - Ability to remove the 'multiple items found' error

I've created the following custom button on my custom object to automatically lookup the contact and account names when the custom 'new' button is selected from a contact's related list: ...
0
votes
0answers
22 views

Subset of Accounts Object

I'm trying to create an object that has a lookup to Accounts that will hold say 5 out of 25 accounts. Then another custom object will have a lookup to only those 5 accounts. My problem is the lookup ...
0
votes
1answer
75 views

Roll up Summary via trigger for lookup relationship

I am trying to get this trigger to work but it is giving me an error and I am not able to figure out why. The error I am getting is "attempt to de-reference a null object) Why trigger? We have a ...
0
votes
0answers
38 views

Override Contact Lookup with Visualforce page

I have been experimenting with Jeff Douglas' "Roll your own Salesforce popup window," http://blog.jeffdouglas.com/2011/08/12/roll-your-own-salesforce-lookup-popup-window/ I have configured it ...
1
vote
2answers
81 views

Can Many to Many relationship be achieved using lookup relationship?

My question is... We normally create master-detail relationship to achieve many to many relationship. Instead of using master-detail relationship on junction object can i use lookup relationship to ...
4
votes
1answer
44 views

Can you create a Lookup to a Task?

I do not see Task/Activity/Event as an option for a Lookup on my custom Lookup on the Case object. I know Tasks are treated differently than other object but I cannot find any documentation stating ...
2
votes
2answers
189 views

Lookup field not populating on Visualforce page

I have a custom visualforce page and controller and am attempting to populate a lookup field on that page. Often the lookup will contain a value already, and I would like for the value to . According ...
1
vote
2answers
48 views

Is there any way to insert data into a lookup field without an associated relationship sObject until the real data can be inserted?

How can I programmatically create an object with a lookup field to an object that would be added at a later time? Is it possible? If yes, what is the best way to do it? I would like to use this to ...
1
vote
2answers
61 views

Auto populate fields based on lookup field value

There is a contact lookup field in opportunity object. When ever user selects the contact value, the shipping custom fields in the opportunity should be auto populated with the mailing address values ...
0
votes
3answers
29 views

Lookup Filter criteria on an object

When you have a Lookup Relationship with defined Filter Criteria, you cannot provide a Profile or User with the option to override or neglect this Relationship. If you are using active Integration or ...
3
votes
2answers
259 views

Auto Populate a Lookup Field based on a field value

We have a custom object "OrderItem__C". This custom object has a lookup field to standard contact object. It also has a field called "Shipping_customer_number__c". We have this same ...
0
votes
1answer
42 views

New Button on Lookup Search Layout

On my Opportunity object I have a look up to Primary Contact. I would to enable users to create a New contact when using the lookup. I would like to have a 'New' Button next to 'Search' search layout. ...
0
votes
2answers
59 views

1 to 1 look up for a field on the same object

I am trying to do a 1-1 look up relationship of the same object. This is the situation: I have a look up in my account called partner (Partner__c) and it is a look up to the same object (account). ...
2
votes
1answer
96 views

How to disable or readonly lookup field in standard page

EDIT: On a standard page. NOT using VF page Is it possible to write a validation rule or any approach to make a field disabled once the user save? I have a page with couple of fields including ...
5
votes
1answer
90 views

Account lookup on Opportunity not filtered correctly from Visualforce page

Visualforce Our organization uses a Visualforce page to override the New Opportunity action. Below is a functional sample of the Visualforce page that specifies the Account lookup field and ...
0
votes
1answer
47 views

Filter Account Lookup by Record Type to match correlated Opportunity Record Type

Notice: The below question does not address the issue we were trying to solve. The real issue had to do with a Visualforce component (see the update). Jenny B's answer provides good information for ...
0
votes
1answer
220 views

Make Lookup fields read only on a VF page

I have a VF page for creating a new record for a custom Object. It looks like this There is a lookup to Service_Contract__c. I needed to autopopulate it (which was the whole reason behind creating ...
3
votes
0answers
29 views

Custom Mapping Parameter File

This is kind of an odd scenario and I was wondering if anyone had seen anything like this before. We have a custom object called Financial_Account__c which stores information about our customers' ...
1
vote
2answers
55 views

How does the default contact name field on case work?

There is a default field on the Case object that uses a lookup on Contact to display the contacts name. I need to make a custom field on Case that displays a custom text field from the Contact ...
1
vote
2answers
43 views

Error on Lookup

i have a new problem, I receive the error message List has more than 1 row for assignment to SObject Trigger.MoveAtt: line 9, column 1 for the following trigger. trigger MoveAtt on Attachment ...
2
votes
3answers
162 views

Simple lookup query failing, I'm not sure why

I have 2 Custom Objects, Parent and Child. Child has a lookup relationship with Parent. If I query Parent__c on the Child object, I get back the Parent object's Id, which is correct, But if I ...
0
votes
1answer
40 views

Lookup filter on a junction object [closed]

I need to make a lookup on Object A that looks up on the Contact object. Filter Criteria: Object A has an event attached to it. The event has a list of contacts. How can I create a lookup filter ...
0
votes
0answers
37 views

2 Lookups of the same object

Facing an issue with 2 look-up fields of same object. When i used both the fields on the same page only one is getting selected. Steps to reproduce - 1. created 2 look-up fields of same object 2. ...
0
votes
1answer
59 views

Update newly created record's lookup field, using Id from just created lookup relationship

I need to create a new Case, populate the Case's lookup Project__c field with the Id of the Project which the Case has been created from, then populate the Program__c lookup field with the Id of the ...