Help with Apex class querying the parent of a child record

Question

I am trying to write a visual force page with extension to show the Parent records on a child record. In this situation, many cases (custom child object) are associated with Products(parent lookup). Also, many parent products may have the same cases associated with them.

I can display the cases associated to products in the related list. But the use case requires the parent products to be visible at the child level.

controller code:

public class CaseParentExt {

    public List<L1dlF0rm0rg__ICIX_Product__c> prods {get;set;}

    public static L1dlF0rm0rg__Case__c.Id caseId;

    public CaseParentExt()
    {
        //line 9:           
        prods = [ SELECT Id, Name FROM L1dlF0rm0rg__ICIX_Product__c where  Id = :caseId];
    }
    return prods.Id
}

Error I am receiving:

Line 9: sObject type 'L1dlF0rm0rg__ICIX_Product__c' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.

Answer 1

If it is a lookup you can query the fields required directly:

[Select L1dlF0rm0rg__ICIX_Product__c, L1dlF0rm0rg__ICIX_Product__r.Name From Case Where Id = :caseId]

this gets you the ID and the Name.

Lookup fields from the parent are singular and not queried like related lists.