Guest Tracy Posted November 2, 2006 Share Posted November 2, 2006 This may be the wrong forum to ask this of ... but here it is:I have an Access database, with a 1 to many relationship (1 title, many subjects). I make a nice query/report then Export it to xml. The problem is the xml document repeats all records with multiple subjects.For example:<record><title>XML World</title><subject>databases</subject></record><record><title>XML World</title><subject>web standards</subject></record>What I want is:<record><title>XML World</title><subject>databases</subject><subject>web standards</subject></record>I've read how to make the xsd schema to do this with maxoccurence=unbounded for the subject element.How to I either tell Access to do this or how do I re-query the xml data so that my output in a static html page only shows 1 title with many subjects per record??My real goal is to get an easy html page of my Access report that has a pretty format with clean, standards compliant code. Thanks for any ideas.-Tracy Link to comment Share on other sites More sharing options...
utopia Posted November 4, 2006 Share Posted November 4, 2006 why not just use a server langauge such as ASP ... real easy! and no xml convertion required, however, converting it into XML is possible with ASP as well .... or write a vb program that does the job for u Link to comment Share on other sites More sharing options...
boen_robot Posted November 4, 2006 Share Posted November 4, 2006 This can surely be done with XSLT, by the usage of xsl:key.Scince I haven't played with it enough yet, I can't point you how exactly to do this though. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now