+ Start a Discussion
PuranKishorePuranKishore 

Triggers Query connection for case, contact and account

trigger MyCaseFirstFile on Case (Before insert)
{
for(Case ca:Trigger.new)
{
Contact con=[Select Phone,Name from Contact where (Account acc=[Select id, AnnualRevenue,Rating from Account where id=:con.Accountid)]];
Phone=9999999999;
update con;
}
}

prady-cmprady-cm

Not sure what you are trying to achieve here...

Could you eloborate on what the business requirement is