Hi Alex, please find below solution as per below relationship: Report Entity Has Lookup of Floor entity and Subgrid of Rooms Relationship: House 1 –> * Floor and Floor 1 –> * Rooms One House Multiple Floor One Floor Multiple Rooms 1. retrieves the current floor from the report. Answer: From FormContext, we can get the Floorlookup value and Store it in Variable. 2. retrieves the house from the current floor. Answer: Once Floor retrieved from formcontext then we can retrieved the house using Xrm.WebAPI.retrieveRecord. 3. with that house retrieve all floors Answer: Now in Success call back of above function we need to retrieve the all floors using Xrm.WebAPI.retrieveMultiple. 4. and than create a filter that retrieves all rooms on all floors in that house Answer: Now in Success call back of above function we need to retrieve the all rooms using Xrm.WebAPI.retrieveMultiple. below is sample code snippet for your reference function onChange(executionContext){ var floor= formContext.getControl(‘floorlogicalName’).getValue(); //get house lookup from floor Xrm.WebApi.retrieveRecord(“floorentitylogicalName”, floor.id, “?$select=housefieldlogicalName”).then( function success(result) { var houselookup=result.entities[0][‘houselookuplogicalname’]; }, function (error) { console.log(error.message); // handle error conditions } ); } function getAllFloors(houselookupid) { var fetchXMl=” “+ ” “+ ” “+ ” “+ ” “+ ” “+ ” “+ ” “+ ” “; var flooridList=[]; Xrm.WebApi.retrieveMultipleRecords(“floorentitylogicalname”, “?fetchXml=”+fetchXMl).then( function success(result) { for (var i = 0; i “+array[index]+” “; } let fetchXMl=” “+ ” “+ ” “+ ” “+ ” “+ ” “+ filterCondition+ ” “+ ” “+ ” “+ ” “; Xrm.WebApi.retrieveMultipleRecords(“roomentitylogicalname”, “?fetchXml=”+fetchXml).then( function success(result) { for (var i = 0; i < result.entities.length; i++) { console.log(result.entities[i]); } // perform additional operations on retrieved records }, function (error) { console.log(error.message); // handle error conditions } ); } Thanks, pradeep. Please mark this as VERIFIED if it helps.