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

0
votes
0answers
21 views

Need to connect 2 custom objects together using an external ID and a Trigger

I have 2 objects which are parent and child. I am using Layer 2 Cloud Connect (Need to do it this way because it does replication and automatically updates any field changes between the 2 records) to ...
0
votes
1answer
32 views

Need Help on Setting lookup field value in trigger [on hold]

I Need Help on Setting lookup field value in trigger Create custom object with label 'Demo Object' and API name Demo_Object. Create a 'text' field with label 'Category'. Create a 'lookup' field for ...
2
votes
1answer
18 views

Best way to set up a Lookup filter for record type on managed package

I have a lookup filter on a lookup field from one Custom Object to another; both objects are within a managed package. Let's assume we have one Object A, with a lookup field lookup__c and another ...
0
votes
1answer
19 views

How do I assign a variable to LookupRows results?

Basically, I want to print out the results from LookupRow, I have tried quite a few different things but to no avail. For example it would find all of the email addresses (maximum 4), that have the ...
0
votes
1answer
30 views

How to Autopopulate the Contact lookup Field with contact name on the Visualforce page?

I have created the below VF page now i want to auto-populate the contact lookup field on the page with contact name.i am displaying this page when user clicks a button on the related list of contact ...
0
votes
1answer
37 views

How to get the Salesforce Lookup id from visualforce to apex

I have public Opportunity destOpp {get; set;} in my apex code. I have <apex:inputField label="Source Account" value="{!sourceOpp.AccountId}" /> in my vf page. After I select an account from ...
1
vote
2answers
35 views

Using LookupRows to retrieve from synchronized data extension

I'm having trouble with the ampscript LookupRows to grab data from a synchronized data extension. Here is what I have so far: %%[ var @rows, @row, @first set @rows = ...
1
vote
2answers
26 views

Updating lookup field on a custom object using another text field as a reference

Very new to coding and need a little help populating a lookup field. I have object Account and custom object Order__c. On Account we have a Ship_to_Code__c which stores an ID. This ID is also part of ...
1
vote
0answers
40 views

Best practice: Lookup relationships and name/value pairs

Say I have a one-to-many lookup relationship between 'Parts' and 'PartsCategory' objects. Something like say the following example records: Part, Price, Brand, Model, CategoryCode: Front fender, ...
0
votes
0answers
18 views

Lookup reference using external Id in mulesoft

Anyone have experience in loading child record and associate parent using parent_external_id__c field. for custom objects ex: Load child__c record and associate Parent__c object using ...
0
votes
1answer
19 views

Fetching data from Object -Scenario

I have an object Client with lookup to Account. I have another object Propose with lookup to Account. I have another object Order with lookup to Client. I want to fetch data from Order object where ...
1
vote
1answer
18 views

Update Account Lookup field by comparing custom field text, looking for exact match

Newbie here, just starting to learn how to code via trailhead and anything I can find online, while also trying to solve org problems in the real world of salesforce CRM, so am hoping someone can help ...
1
vote
1answer
17 views

Lookup dialog must return records related to the junction object

In my requirement I have a junction object between Account and Contact. Now there is a requirement that on the case object, where standard lookup field of contact and account are present, when I have ...
1
vote
1answer
22 views

Pull OpportunityContactRole value into VisualForce Template related to an Invoice

We're setting up a workflow to notify the finance department when an Opportunity owner flags an invoice as "ready to be sent". I've got a VF email template, relatedTo="invoice", and I want to pull ...
1
vote
0answers
15 views

Look up field not getting updated

I experienced this issue sometime back and do not remember a fix for it..I am trying to update a look up field for an object on a custom object. When i try to save it, the history says shows that it ...
0
votes
2answers
23 views

Is there a safe way to autofill values into a lookup field

I have junction object called Application and its related to contact and custom object postion. We also have a interview object which has a lookup to Application. position and contact. When i click ...
0
votes
1answer
26 views

Unable to configure Lookup Filter

I,ve one Parent object 'Patient' and Child Object 'Patient Services' and another Parent object 'Job'. On Patient Services Object one Look up field Named Patient related to Patient object & ...
1
vote
1answer
42 views

Newly created field not appearing on object filter criteria

I've created a new field in the Order object, it's a text field that is filled with a Name from another custom object. I want to use the text field in the filter but it doesn't appear in the list of ...
2
votes
1answer
26 views

Visualforce lookup to Account

I am developing a page which will allow a user to select an Account and it will use that Id to construct a URL. I have no objects in my org with a lookup field to Account, and therefore I cannot use ...
2
votes
1answer
22 views

Is there a way to have a lookup / free text field in Salesforce?

We would like our Staff (interal salesforce users) to be able to populate a field based upon a lookup of data in a custom object when submitting a Case. In contrast we also have an online form for ...
1
vote
1answer
23 views

Lookup field value in controller extension

I am creating a page where I am able to create a new case related the contact. In my controller extension in createCase() method, I am unable to populate the contact field( Lookup object on case). ...
0
votes
0answers
15 views

Dynamic picklist change based on Account value in opportunity page (standard) of Salesforce

Have a requirement where we need to remove a value from the picklist based on the Account name that is getting chosen. For example i have a picklist that has - A,B,C,D as choices. But , if i choose ...
0
votes
0answers
17 views

activities with multi select look up

I need help with finding a solution to a multi-select lookup in activity (Event in particular). Literally it should be a clone of the field Name (who -> Lookup(Contact,Lead). Activities does not ...
1
vote
1answer
19 views

Creating Visualforce account information form with account lookup

I am creating a VF form with account information input fields as well as other custom fields. I would like to create a lookup field for the user to select the account to work in. I am able to create ...
1
vote
1answer
56 views

Difference between dependent lookup and lookup filter

What is the difference between a dependent lookup, required lookup filter and optional lookup filter. I found those three concepts in many tests of salesforce and i didn't understand it.
0
votes
0answers
28 views

Custom Salesforce Lookup (Lookup/Create Account within Visualforce page using a visualforce page/class)

I have designed two lookup pages based on Jeff Douglas' article Roll Your Own Salesforce lookup, one for contacts and the other for accounts. The goal is to be able to create a contact and either ...
1
vote
1answer
24 views

Do standard lookups always follow: FieldName = RelationshipName + “Id”?

Can we say that all standard lookups/master-details/polymorphic fields follow a consistent naming convention across all standard objects? I'm talking about this pattern: field name = field ...
0
votes
2answers
42 views

Trigger lookup just not working

I am trying to populate a lookup field based off of a list of records in a different object. The problem is the 2 objects are not related but they have a field that is the same. Is it possible to do ...
0
votes
1answer
43 views

Get field values from an Account via look up.

In a custom object I have a look up for account. so once the account is selected from the account list the object will be somehow connected to the account. I need 2 fields in that custom object that ...
1
vote
1answer
21 views

Lookup object return null in trigger

For all this time, what I understand that I can get through look up field object such as Owner Name directly without need to write query, but after writing this code, it seem like I understand it ...
5
votes
1answer
49 views

What happens to Master-Detail after deleting (Managed Package)

When I delete a Master-Detail relationship in my managed Package Will it be replaced by a Lookup, like this Knowledge arcticle says? Will there still be a Master-Detail relationship in our customers ...
1
vote
1answer
29 views

Not Possible To Use Multiple LookupRows in a single HTML paste?

First time poster. I'm trying to use multiple LookupRows in a single HTML Paste. While I don't see anything in the documentation saying that this isn't possible. %%[Set @DE1Result = ...
0
votes
1answer
30 views

How to retrive time from standard look up field in opportunity

Hi i got a requirement like to get time in standard look up called CreatedBy in opportunity page. Is it possible to retrieve only time from that field. Because it is Look up relationship of user.I ...
1
vote
1answer
45 views

How to Give Default value to a LookUp field using Formula Editor

I have an action on which i have one Lookup Field "Year".Year is an object with only two records - 2015 , 2016. I have this value to be predefined as 2016 when user clicks an action While creating a ...
0
votes
1answer
58 views

Add new button to Custom Object Lookup dialog box

I have a number of lookup fields on an object. When I click the magnifying glass to select items from the lookup the Account and Contact object lookup dialogs have a "New" button next to the go. ...
1
vote
1answer
34 views

How to display lookup field using <apex:inputField [closed]

How can I have a lookup field <apex:inputField value="{!myobject.name}"/> //displays the name <apex:inputField value="{!myobject.id}"/> //displays id
0
votes
1answer
24 views

Match “custom ID fields” from Acc. and Cust.Obj and update lookup field with ACC Name by ID

i facing following issue: We Have Obj. Account and Obj. B__c. On Object Account we have a ID__c which stores an ID. Now we get this ID from an external System written in an text field on Obj. B__c ...
0
votes
0answers
56 views

How do I create a many-to-many relationship to the same object?

I have a need to create a hierarchy of products, where one product is the 'base' product and other products are used to make up a final item. For example the 'base' product is a chair, but the ...
3
votes
1answer
23 views

Update a drop down on a flow based on input on the same screen

In a flow Is it possible to update the choices of a drop down list on the same screen as the input? For example I have text field; enter zip code, this then filters a drop down list to allow users to ...
0
votes
0answers
17 views

How can I have an Account Field update if the Account has ever been quoted equal to or greater than a set number?

I am looking to have the Account record's field, let's say a checkbox for "High Profile," update if the Account has a Quote Total greater than a set number -- $10k, for instance. Thanks
3
votes
0answers
48 views

trigger to populate manager's manager in a lookup field

Way too new at coding to be able to figure this out, hoping someone has done this and can help me out or get me started. Need to use the managers' manager on an approval process for a custom object ...
0
votes
1answer
25 views

Changing all Contact owners in an Account when user lookup field on Account changes

I have a user lookup field on the Account that I want to control ownership for all the Account's Contacts. So for example, if the Account is owned by User1, and my user lookup field says User2, all ...
-1
votes
2answers
81 views

Apex input field of Type lookup is taking “Name” instead of “ID”

I have a inputfield of type lookup. It should contain Id of the reference Account but it takes the Name. Alert is showing name of the Account, where it should return Id. Please Advise. ...
1
vote
1answer
60 views

AMPscript: Using date in LookupOrderedRows is not working

I would like to use date LookupOrderedRows() My code: SET @DetailRows = LookupOrderedRows("ST_Import_date", 1, "ID ASC", "Import_Date", Format(now(),"MM/dd/yyyy")) When I try to get the rows with ...
1
vote
3answers
203 views

Check lookup field is null in apex

What is the best approach to check if a lookup field is null in apex? rec.lookupField__c == null; // OR rec.lookupField__c == ''; // OR String.isBlank(rec.lookupField__c ) // ? I ...
0
votes
0answers
40 views

Pass input field lookup value to standard controller

I have below Page code which I am unable to put values to the new record instance that gets inserted with commandbutton click. Can someone please let me know? Apex page <apex:page ...
1
vote
1answer
24 views

User lookup in my custom object is not showing the list of users available!

i have a custom object called ticket__c . it contains a field called user which is a lookup field for user object . while creating a new object onclicking the user lookup , it goes to a page but no ...
0
votes
1answer
30 views

Seeing all records in lookup dialog

Could we make the standard lookup dialog more usable. When new users enter the org and try to create a record with a lookup field in it- since they are not aware of the existing parent record names it ...
2
votes
1answer
46 views

Find the max owner for a given record

Schema I have a scenario where two records are related via Lookup. A -> B(has Lookup[A]) So parent A can have many related children B objects. Since A and B are related through lookup and ...
2
votes
3answers
77 views

Iterate over queried lookup fields

Example: Opportunity Opp = [SELECT Name, Status__c, Zone__c, Invoice__r.Amount__c, Invoice__r.Date__c FROM Opportunity WHERE ID ='006a12nlfoenlew']; I need to iterate over each field and see if ...