I need to create an XML file from Access. It has to have a relational node type format.

For instance:

```
<Item>
   <description></description>
   <colors>
         <blue>
         <green>
   </colors>
</item>

```

The data for the items is in a table. The colors are in another. I have reference IDs so I can join them.

How/can this be done. I have looked all over and see how to export a table, but not the nested type of file.