You need to sign in to do that
Don't have an account?
Kemp100
Add to lookup field
I am trying to add a value to a LOOKUP field from a API. It for some reason wont add the value
the LOOKUP field is holding a name so i'm supplying it "first last"
am i doing anything wrong? the syntax is correct.
I am having the same problem. I have added a lookup field to the Account object called Region. This is a lookup to another Cutom object/table Regions.
In .NET if I view the sforce object in the Object browser I see Region__c() as string and Region__r() as Sforce.Region__c
If I do a query through the API with query string "SELECT Region__c From Account" I get the Id for a given region from the Regions object/table.
If I do an update setting Region__c equal to the Id for a different region, it does not update.
Also, If I do a query through the API with the query string "SELECT Region__c, Region__r FROM Account" I get an error stating Region__r does not exist.
Do I need to set Region__c and Region_r when updating?
For other custom fields, when updating through the API, I have found that I have to set CustomField__c to the desired value and set CustomField__cSpecfied = "True" for the update to take place.