---

 

we are getting the entire object here  :

 

Map<id, AMProducts__c[]> mProdAMProd = New Map<id,AMProducts__c[]>();

 

I just need to get the list of IDs only. Is there a way and Can you help with this change please.

 

Thanks a lot

JL

---

You are getting just a list of ID's for the Parent, and a List of Children with just the name field...

Let me break it down more for you:

//Create a new Map variable and set it to an empty object
Map<id, AMProducts__c[]> mProdAMProd = New Map<id,AMProducts__c[]>();

//Get records using nested select
//This Gets the ID for ALL Product Where xxxxxxxx and the Inner Select returns the Name form each child related to the Product
// i.e. AccountID='1234'({ID='111', Name='First Child'},{ID='222',Name='SecondChild'}), AccountID=xxxxxxxx
Product[] prod = [Select ID, (Select Name From ****child API name**** (i.e APProducts__r) from Product Where xxxxxxxx];

//Build Map
//Put the ID for each Product in the map, and the list of children so ID 1234 will return the list of children associated with that product id
For (Product p : prod){

  mProdAMProd.put( p.id, p.***child API Name***(i.e. APProducts__r));

        //  mProdAMProd.put( p.id, p.APProducts__r); as an example
}