How to use the XSD file to build an XML file?


I have 4 tables populated with data and a Schema file XSD that has the definition on how the XML file should look like

<file1>
   <field1></Field1>
   .
   .
   .
</File1>
<file2>
   <field1></Field1>
   .
   .
   .
</File2>
<File3>
   <field1></Field1>
   .
    <File4>
     <field1></Field1>
     .
   </File4>
<File3>

as you can see file3 and File 4 are related

When I receive and XML document and use the XMLAdapter with the XSD file I get the 4 cursors as it should however how do I get an XML file out on these cursors.

I tried set a relationship ( SET RELATION ) on them but the result XML does not follow the relationship:

<file1>
   <field1></Field1>
   .
   .
   .
</File1>
<file2>
   <field1></Field1>
   .
   .
   .
</File2>
<File3>
   <field1></Field1>
   .
<File3>
<File4>
   <field1></Field1>
   .
</File4>

I’m at a loss here I don’t know how to make the XMLAdapter to use the XSD provided as a template to build the XML file

Any ideas?