I have recently hit a a dead end with excel in my pursuit to develop a database that will generate a useful XML page, mapped with a schema I've given. Teh part Im having difficulty is the "list of lists" bit where each of my main entries will have its own unique table, with repeating children nodes. I clearly dont even know the right terminology so to make things absolutely clear what I'm aiming for is a website for an architect which I hope can be orchestrated from a central DB. The main bit of the site is a "projects" section and each project will show several images, and not necessarily the same amount [though i suppose i can budge on that last detail].
In order to do this, am I to make master table and a unique child table for each of these entries? What is a good approach for this?
the xml schema (sketch):
Code:
<Prjct>
<Number></Number>
<Name></Name>
<Date></Date>
<Client></Client>
<Type></Type>
<Scope></Scope>
<Remarks></Remarks>
<Description></Description>
<Location>
<City></City>
<Province></Province>
<Country></Country>
</Location>
<Images>
<Image>
<Thmb></Thmb>
<Img></Img>
<Ttl></Ttl>
<Cptn></Cptn>
</Image>
<Image>
<Thmb></Thmb>
<Img></Img>
<Ttl></Ttl>
<Cptn></Cptn>
</Image>
</Images>
</Prjct>