XML Nested List from Cascading Relations

[Guest]

Hi,

Does anyone know a simple way to create an .xml file containing a nested
list from a set of cascading relations.

In other words if I have tables for Catalogue, Section, Page, Product.

The output would be

Catalogue
Section
Page
Product
Product
Page
Product
Section
Page
Product
Catalogue

Thanks in anticipation

I can use Access 2002 or 2003 (would prefer 2002 for these users)

Craig

 

[Joe Fallon]

A2003 has the best support for XML of any version.
I know it can do related tables but I am not sure about how many and how
deep.
Also the format will correspond to a MS design. So unless you can use it "as
is" you may need to transform it.