Sign Up ›

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

parent child relationship error

First_Visit__c parent object , time__c child object, times__r relationship name

i am getting error: Invalid field hours__c for SObject First_Visit__c

Code 
if(Trigger.isUpdate)
        {
          	Map<Id,First_Visit__c> childrenToUpdate = new Map<Id,First_Visit__c>();
			for(First_Visit__c parent : [Select Id,(Select Id,Hours__c From Times__r) From First_Visit__c Where Id in :trigger.newMap.keySet()]){
  	        for(First_Visit__c child : parent.Times__r){
           // Could use a list, but Map ensures that we wont have duplicate records.
          	  childrenToUpdate.put(child.Id,child);
  		      child.hours__c = parent.Time_Taken__c ;
        
    }

 
YuchenYuchen
So this hours__c filed is on Times__r not on First_Visit__c right? Maybe in your inner for loop, you can change "First_Visit__c child" to "Time__c child".
MithunPMithunP
Hi NikunjVadi,

Just update your second for loop like this   ""   for(Times__c child : parent.Times__r)   ""

Here is updated code 
if(Trigger.isUpdate)
        {
          	Map<Id,First_Visit__c> childrenToUpdate = new Map<Id,First_Visit__c>();
			for(First_Visit__c parent : [Select Id,(Select Id,Hours__c From Times__r) From First_Visit__c Where Id in :trigger.newMap.keySet()]){
  	        for(Times__c child : parent.Times__r){
           // Could use a list, but Map ensures that we wont have duplicate records.
          	  childrenToUpdate.put(child.Id,child);
  		      child.hours__c = parent.Time_Taken__c ;
        
    }



Best Regards,
Mithun.
NikunjVadiNikunjVadi

thanks for the response
updated to time__c

Incompatible value type SOBJECT:Time__c for MAP<Id,First_Visit__c>