You need to sign in to do that
Don't have an account?
Sumant Kuchipudi
How can I pull parent's another child record field.
Hi,
I have a Custom object (Transaction) which has Lookup(Account) field and in Contact object I have a custom field (ABC_internal_id). I need to access ABC_internal_id field with the SOQL query on Transaction object (by transaction ID). It might be a simple question but please let me get the clue.
I have a Custom object (Transaction) which has Lookup(Account) field and in Contact object I have a custom field (ABC_internal_id). I need to access ABC_internal_id field with the SOQL query on Transaction object (by transaction ID). It might be a simple question but please let me get the clue.
Get the Transaction__c object account id
Transaction__c t = [Select Id,Account__c from Transaction__c ] ;
You may get more than one contacts for each account . so use this query
List<Contact> con =[Select Id ,ABC_internal_id from Contact where accountId =t.Account__c] ;