I have constructed a DB with a main table of projects with another one of images, each image tied to one of the projects. I am a noob to DB construction so please bare with me.

What I am trying to do is have Access generate XML whereby each project is a repeating root element and within each all images which belong to this project are nested within it. The schema roughed out:

Code:
<Project>
  <Number></Number>
  <Name></Name>
  <Date></Date>
  <Client></Client>
  <Type></Type>
  <Scope></Scope>
  <Remarks></Remarks>
  <Location>
    <City></City>
    <Province></Province>
    <Country></Country>
  </Location>
  <Images>
    <Image>
      <Thumbnail></Thumbnail>
      <FullImage></FullImage>
      <Title></Title>
      <Caption></Caption>
    </Image>
    <Image>
      <Thumbnail></Thumbnail>
      <FullImage></FullImage>
      <Title></Title>
      <Caption></Caption>
    </Image>
    <Image>
      <Thumbnail></Thumbnail>
      <FullImage></FullImage>
      <Title></Title>
      <Caption></Caption>
    </Image>
    <!-- As many of these as you need -->
  </Images>
  <Description></Description>
</Project>
my trouble is understanding how to force/implement this schema on the export function - or if this is not possible or not the correct way of doing things, can you suggest a better way???

thanks so much in advance - I am really out of my element and I dont even know the correct search terms to do my own research...

thanks in advance!