function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
IkoIko 

Queries on Custom Objects with Linked Standard Objects

Hello everyone,
 
I hope I got the subject title right...very new to salesforce...
 
I have a custom table (of objects) that includes a lookup field to "Contact". I am using VBA and the office toolkit lib to connect to SF and to query the table. Everything works as expected, and if I inspect the "Contact__c" field retrieved in a record (object) I do get the internal ID. Of course I would like to retrieve the Contact Name ... but hopefully without starting additional queries. In ADO / SQL I would just do a select with an inner join....
 
What do I have to do in  SOQL to achieve the same?
 
Any help is greatly appreciated.
 
Iko
 
Mens sana in "codere" sano
Ron HessRon Hess
until the relationship query feature is released, you must run an additional query to get the details from the contact.

this is an often requested feature, and is on the roadmap.
IkoIko
Thanks for the fast response. Comforting to know you guys react swiftly. Also good to know that I don't have to try figuring it out on my own...