CAM,
You can write a few lines of VBA code to output the data in .xml format.
Set rs = db.openRecordset("SELECT Catalogue FROM Catalogues;")
do until rs.eof
xmlStr = xmlStr & "<Catalogue>" & rs("Catalogue") & "</Catalogue>" & vbcrlf
set rs1 = db.OpenRecordset("SELECT DISTINCT Section FROM Sections WHERE
Catalogue = " & rs("Catalogue") & ";")
do until rs1.eof
xmlStr = xmlStr & "<Section>" & rs("Section") & "</Section>" & vbcrlf
set rs2 = db.OpenRecordset("SELECT Page FROM Pages WHERE Catalogue = " &
rs("Catalogue") & " and Section = '" & rs1("Section") & "';")
do until rs2.eof
xmlStr = xmlStr & "<Page>" & rs2("Page") & "</Page>" & vbcrlf
etc.
etc.
etc
"CAM" <CA*@NOCONTACT.COM> wrote in message
news:40********@mk-nntp-2.news.uk.tiscali.com...
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
Craig