Results 1 to 2 of 2
  1. #1
    oompa_l is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    2

    noob requiring help with database of projects, each of which will have its own list

    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>

  2. #2
    oompa_l is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    2
    so I finally have my relational database together with a primary table for projects and another for images, each of which ties back to one of the projects. A query brings the two together but what is still unclear to me is how to control the XSD and XML being generated by access upon export.

    does anyone know how to manipulate this so that there is a nested list of entries within a top tier list of elements? anyone know about the general technique of changing the way the XML schema is formed?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Some questions from a noob
    By Seamus in forum Database Design
    Replies: 3
    Last Post: 04-30-2010, 05:47 AM
  2. Using Access Projects
    By ragsgold in forum Access
    Replies: 4
    Last Post: 10-24-2009, 04:23 AM
  3. Noob needing answers
    By sartan2002 in forum Access
    Replies: 0
    Last Post: 10-13-2009, 08:39 AM
  4. report to compare projects' targets
    By Arest in forum Reports
    Replies: 0
    Last Post: 07-29-2009, 09:04 AM
  5. Noob Query Help Needed
    By fenster89411 in forum Queries
    Replies: 0
    Last Post: 01-11-2009, 09:47 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums