How can i call relationship object fields in Salesforce trigger?

Hi Naman,

Here is the solution for what I understand from your question:

Suppose you have a trigger on Contact and you want to access Account fields.

trigger afterInsertContact on Contact (after insert){
for(Contact conObj : trigger.new){
system.debug(conObj.AccountId);
}
}

For standard relationships, you can simply use the . (dot) notation and refer to the fields.
However for a custom relationship, you need to use __c and __r.

Thanks

We have two object account and contact. In this scenario, you have a contact object which has a lookup relationship to account. When processing the contact records in your trigger, you want to access some fields on the account via the relationship. Your trigger might look something like this:

trigger parent2child on Account (after update) {
    list<id>ids = new list<id>();
    list<contact>conlist = new list<contact>();
    for(account a:trigger.new){
        ids.add(a.id);
        list<contact>con =[select id,phone,account.phone from contact where accountid in:ids];
        for(contact c:con) {
            c.Phone=c.account.phone;
            conlist.add(c);
        }
        update conlist;
    }
}

• This reply was modified 7 years, 3 months ago by  William.