+ Start a Discussion
DarthZorcDarthZorc 

Relationship queries in Eclipse

I am trying to run the following 2 simple relationship queries in Eclipse and can not get them to take. I getand error saying it didn't understand the relationship be sure to append the __r. Can anyone assist?

 

Example Child to parent:

Select TIMEHDR__r.name,  Id, Name,  Date__c,  Project__c, Project_Task__c, Hours__c

 

From TIMEDET__c

 

 

Example Parent to child

 

select id, name, Time_Card_Period__c,

(Select id, Name, Project__c, Project_Task__c, Date__c, Hours__c From TIMEDET__r )

 

from TIMEHDR__c

 

sunil316sunil316

 

 what is your parent object name and child object name in this?

 

 

 

-Sunil 

 

DarthZorcDarthZorc
The parent object is TIMEHDR__c and the Child object is TIMEDET__c