title: Refresh Nested DataSet with poFetchDetailsOnDemand
body: <p>Is there a way to refresh only the Detail DataSet without reloading all master dataset?</p>
  
  <p>this is what I've tried so far:</p>
  
  <pre><code>DM.ClientDataSet2.Refresh;      
  DM.ClientDataSet2.RefreshRecord;
  </code></pre>
  
  <p>I have also tried: </p>
  
  <pre><code>DM.ClientDataSet1.Refresh;
  </code></pre>
  
  <p>But the method above refreshes the entire Master dataset, not just the current record.</p>
  
  <p>Now, the following code seems to do anything:</p>
  
  <pre><code>DM.ClientDataSet1.RefreshRecord;
  </code></pre>
  
  <p>Is there a workaround or a proper way to do what I want? (maybe an interposer...)</p>
  
  <p>Additional Info:</p>
  
  <p><strong>ClientDataSet1 = Master Dataset</strong></p>
  
  <p><strong>ClientDataSet2 = Detail DataSet , is the following: *</strong></p>
  
  <pre><code>object ClientDataSet2: TClientDataSet
      Aggregates = &lt;&gt;
      DataSetField = ClientDataSet1ADOQuery2
      FetchOnDemand = False
      .....
  end
  </code></pre>
  
  <p>Provider properties:</p>
  
  <pre><code>object DataSetProvider1: TDataSetProvider
      DataSet = ADOQuery1
      Options = [poFetchDetailsOnDemand]
      UpdateMode = upWhereKeyOnly
      Left = 24
      Top = 104
    end
  </code></pre>