<projects> <project> <name> ! Test Project </name> <projectdate></projectdate> <constructiondate> 2006 </constructiondate> <location> Barcelona, Spain </location> <description> <![CDATA[ <p>This is a test project description with two paragraphs</p><p>this is the second paragraph</p> ]]> </description> <type>buildnigGarden</type> <team></team> <budget></budget> <area></area> <client></client> <info> this is a field for extra information, about the clients, the size, price, etc... </info> <directory> test </directory> <images> <image name="test.porch.jpg" title="this is image 1."/> <image name="test.firstfloor.jpg" title="this is image 2."/> <image name="test.firstfloor2.jpg" title="this is image 2."/> </images> <files> <file/> <file/> </files> <status> built </status> </project> </projects>
and i have to store this same information structure in a microsoft access database. i have no idea how to get a list of images or a list of files into an access database, and i'm wondering if i'm way off track with this. i want to end up with a full access database storing all of these projects, where each project can have a number of images and files associated with it, and i need to be able to convert it to xml for storage and retrieval on a web server, to display the contents in a php web page.
do i have to use relational tables to do this? if so, is it easy to output all this to xml?
thanks for the help,