title: Nesting multiple tables/queries on export to XML
body: <p>Is there any way to use the <code>Application.ExportXML</code> method to not only merge multiple queries, but to nest the queries inside each other?</p>
  
  <p>For example, let's say I have three tables. I'm already able to use the <code>Application.ExportXML</code> method to merge the three together. The main queries that I don't want repeating don't repeat, and the one with all the customer info does. Good.</p>
  
  <p>But it comes out like this (for various paranoid reasons I'm using fake data):</p>
  
  <pre><code>&lt;DogCare&gt;
    &lt;Facility&gt;Twin Peaks&lt;/Facility&gt;
    &lt;Year&gt;1992&lt;/Year&gt;
    &lt;Month&gt;1&lt;/Month&gt;
  &lt;/DogCare&gt;
  &lt;DogTeam&gt;
    &lt;Team&gt;DogWalker&lt;/Team&gt;
    &lt;DogsWalked&gt;24&lt;/DogsWalked&gt;
    &lt;TreatsGiven&gt;900&lt;/TreatsGiven&gt;
  &lt;/DogTeam&gt;
  &lt;PetWalkTime&gt;
    &lt;Name&gt;Palmer&lt;/Name&gt;
    &lt;Age&gt;7&lt;/Age&gt;
    &lt;FavoriteSnack&gt;Cheese&lt;/FavoriteSnack&gt;
    &lt;FavThingtoDo&gt;Chew Shoes&lt;/FavThingtoDo&gt;
    &lt;Day&gt;1&lt;/Day&gt;
    &lt;DidBusiness&gt;Yes&lt;/DidBusiness&gt;
    &lt;Barked&gt;Constantly&lt;/Barked&gt;
    &lt;PulledonLeash&gt;Whole Time&lt;/PulledonLeash&gt;
    &lt;DeservesTreat&gt;Gave it Anyway&lt;/DeservesTreat&gt;
  &lt;/PetWalkTime&gt;
  &lt;PetWalkTime&gt;
    &lt;Name&gt;Laura&lt;/Name&gt;
    &lt;Age&gt;5&lt;/Age&gt;
    &lt;FavoriteSnack&gt;Pie&lt;/FavoriteSnack&gt;
    &lt;FavThingtoDo&gt;Fetch&lt;/FavThingtoDo&gt;
    &lt;Day&gt;1&lt;/Day&gt;
    &lt;DidBusiness&gt;Yes&lt;/DidBusiness&gt;
    &lt;Barked&gt;No&lt;/Barked&gt;
    &lt;PulledonLeash&gt;No&lt;/PulledonLeash&gt;
    &lt;DeservesTreat&gt;Gave Several&lt;/DeservesTreat&gt;
  &lt;/PetWalkTime&gt;
  </code></pre>
  
  <p>Now. "DogCare","DogTeam", and "PetWalkTime" are separate queries. Yet, they are all related and belong within each other like so:</p>
  
  <pre><code>&lt;DogCare&gt;
    &lt;Facility&gt;Twin Peaks&lt;/Facility&gt;
    &lt;Year&gt;1992&lt;/Year&gt;
    &lt;Month&gt;2&lt;/Month&gt;
    &lt;DogTeam&gt;
      &lt;Team&gt;DogWalker&lt;/Team&gt;
      &lt;DogsWalked&gt;24&lt;/DogsWalked&gt;
      &lt;TreatsGiven&gt;900&lt;/TreatsGiven&gt;
      &lt;PetWalkTime&gt;
          &lt;Name&gt;Palmer&lt;/Name&gt;
          &lt;FavoriteSnack&gt;Cheese&lt;/FavoriteSnack&gt;
          &lt;FavThingtoDo&gt;Chew Shoes&lt;/FavThingtoDo&gt;
          &lt;Day&gt;1&lt;/Day&gt;
          &lt;DidBusiness&gt;Yes&lt;/DidBusiness&gt;
          &lt;Barked&gt;Constantly&lt;/Barked&gt;
          &lt;PulledonLeash&gt;Whole Time&lt;/PulledonLeash&gt;
          &lt;DeservesTreat&gt;Gave it Anyway&lt;/DeservesTreat&gt;
      &lt;/PetWalkTime&gt;
      &lt;PetWalkTime&gt;
           &lt;Name&gt;Laura&lt;/Name&gt;
           &lt;FavoriteSnack&gt;Pie&lt;/FavoriteSnack&gt;
           &lt;FavThingtoDo&gt;Fetch&lt;/FavThingtoDo&gt;
           &lt;Day&gt;1&lt;/Day&gt;
           &lt;DidBusiness&gt;Yes&lt;/DidBusiness&gt;
           &lt;Barked&gt;No&lt;/Barked&gt;
           &lt;PulledonLeash&gt;No&lt;/PulledonLeash&gt;
           &lt;DeservesTreat&gt;Gave Several&lt;/DeservesTreat&gt;
      &lt;/PetWalkTime&gt;
    &lt;/DogTeam&gt;
  &lt;/DogCare&gt;
  </code></pre>
  
  <p>Is there any way to make that last one possible on export?</p>