ExportXML

This is a repost from a couple of days ago. I didn't get any
responses, and am really hitting my head on the wall with this. Even
knowing that it is a complete impossibility would be welcome news, if
only so I can stop hitting my head. :-)

I've got an Access 2003 db that has many different relationships
between
tables, for example, books <-> book_author <-> authors <->
author_institution <-> institutions. If I do an export xml from the
toolbar, there is an option to choose which data to export, for
example:

- □ books
--- □ book_author
----- [Lookup Data]
------- □ authors
--------- □ author_institution
----------- [Lookup Data]
------------- □ institutions

Regardless of whether I export this way or via ExportXML in a VB
module, I get all the data, but I loose the node structure at certain
points. After trying everything I could think of, or find on the web,
I went back and examined the manual/toolbar option and noticed that
the relationships that fail to be maintained during the automated
process have a "[Lookup Data]" node between the parent and child node
(in the example above, between the book_author and author tables). So
I end up with something like:

<books>
<book_id>1</book_id>
<title>Run Rhonda Run</title>
<book_author>
<book_id>1</book_id>
<author_id>1</author_id>
</book_author>
<book_author>
<book_id>1</book_id>
<author_id>2</author_id>
</book_author>
</books>
<books>...more books...</books>
<authors>
<author_id>1</author_id>
<name>Rhonda Roads</name>
<author_instutute>
<author_id>1</author_id>
<institution_id>1</institution_id>
</author_institution>
</authors>
<authors>
<author_id>2</author_id>
<name>Robby Roads</name>
<author_instutute>
<author_id>1</author_id>
<institution_id>1</institution_id>
</author_institution>
</authors>
<authors>...more authors...</authors>
<instututions>
<institution_id>1</institution>
<name>Lincoln Elementary</name>
</institutions>
<institutions>...more institutions...</institutions>

I tried mucking around with relationships, but I'm always give the
same export options, regardless of table relationship definitions.

Does anybody have any suggestions on how to maintain the parent-child-
grandchildren-greatgrandchildren...
node relationships all the way down a tree during an xml export?

Thanks in advance!

-d
.

Relevant Pages

  • Re: Which of these electronic kits to get
    ... Hitting a mesh bass drum head with the beater is almost ... > $200 left for upgrades or accessories: ... > triggering problem with the Pro snare. ...
    (rec.music.makers.percussion)
  • Re: See Through the Sifu
    ... Repeatedly hitting yourself in the head isn't going to ... This coming from the guy who thinks that hitting yourself in the head ... Most people who fight with any real contact have taken shots to the ... and it landed in the groin area.. ...
    (rec.martial-arts)
  • Re: MMA is just mindless brutality
    ... One can also develop massive power: Not by hitting a persons head.. ... Point sparring is okay occasionally; ... matter how hard you can hit training equipment, ...
    (rec.martial-arts)
  • Re: Internal meter/rhythm test site
    ... Space bar works better than mouse, and hitting end after 11-12 beats is ... better than letting the whole min. run. ... "Hitsville Hits UK" in my head at half speed. ...
    (alt.guitar.bass)
  • Re: Problem with printer friendly support
    ... The moving of the link to the bottom of "head" doesn't ... regardless what I try to do (Murray's suggestion); ... >know which style sheet for print, ...
    (microsoft.public.frontpage.programming)