You need to sign in to do that
Don't have an account?
Error in trigger
trigger AddressToAccount on Address__c (after update) {
/////////////////////////////////
// This Trigger updates the Case status of the related opportunity//
/////////////////////////////////
if(trigger.isafter && trigger.isafter) {
List<Address__c> lstAddress = [SELECT Account__c,Billing_City__C,Billing_State__c,Billing_Country__c FROM Address__c WHERE Account__c IN :trigger.new];
List<Account> lstAccounts= new List<Account>();
for(Address__c ad : trigger.new) {
{
for(Account ac: lstAccounts) {
{
ac.BillingCity=ad.Billing_city__C;
ac.BillingState=ad.Billing_state__c;
ac.BillingCountry=ad.Billing__Country__c;
lstAccounts.add(ac);
}
}
}
}
// Bulk DML
if(lstAccounts.size() > 0) { update lstAccounts; }
}
}
I am getting the following error for the above trigger.
Invalid bind expression type of SOBJECT:Address__c does not match domain of foreign key at line 7 column 139
Please advise.
Thanks!
Is Account__c a vlookup or master/detail field to Account object?
In this SOQL query you are actually trying to compare account id with the custom object Address__c.
Thats why the error.
Also i think "trigger.isafter" is repeated.