Hi folks<br /><br />I have a simple Access 2003 DB that has two queries with a one to many relationship.<br /><br />When I do a Export as xml on the qry on the (one side) and when the export xml dialog box pops up I have selected to export:<br />
<ul><li>Data (XML)</li><li>Schema (XSD)</li><li>Presentation (XSL)</li></ul><br />When I click on the Options button on the dialog box a new dialog box with three tabs pops up. The three tabs are Data, Schema & Presentation.<br /><br />With the Data tab, I have selected the two queries to export. I haven't made any changes to the two other tabs.<br /><br />After exporting the data, I have opened the xml file in IE and it appears as though it is OK - it has data from both queries (see following)<br /><br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec--><br /> <?xml version="1.0" encoding="UTF-8" ?> <br />- <dataroot xmlns
d="urn:schemas-microsoft-comfficedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PurchOrdersAllAndSuppliers.xsd" generated="2007-03-21T06:13:41"><br />- <qryPurchOrdersAndSuppliers><br /> <PurchOrderID>1</PurchOrderID> <br /> <PurchOrderDate>2007-03-17T00:00:00</PurchOrderDate> <br /> <SupplierName>Southern Veterinarian Supplies</SupplierName> <br /> <PurchOrderComment>?</PurchOrderComment> <br /> <SupplierDebtorRef>countryvets001</SupplierDebtorRef> <br />- <qryPurchOrderAndDetails><br /> <PurchOrderID>1</PurchOrderID> <br /> <PurchOrderDetailID>1</PurchOrderDetailID> <br /> <ProductName>injection needles 10 pack</ProductName> <br /> <SupplierRef>injneedl10pk</SupplierRef> <br /> <Qty>3</Qty> <br /> <UnitName>each</UnitName> <br /> <UnitPrice>20</UnitPrice> <br /> </qryPurchOrderAndDetails><br /> </qryPurchOrdersAndSuppliers><br />- <qryPurchOrdersAndSuppliers><br /> <PurchOrderID>2</PurchOrderID> <br /> <PurchOrderDate>2007-03-18T00:00:00</PurchOrderDate> <br /> <SupplierName>Hobart Office Supplies</SupplierName> <br /> <PurchOrderComment>office supplies</PurchOrderComment> <br /> <SupplierDebtorRef>countryv01</SupplierDebtorRef> <br />- <qryPurchOrderAndDetails><br /> <PurchOrderID>2</PurchOrderID> <br /> <PurchOrderDetailID>2</PurchOrderDetailID> <br /> <ProductName>biros 5 pack</ProductName> <br /> <SupplierRef>biros5pk</SupplierRef> <br /> <Qty>2</Qty> <br /> <UnitName>each</UnitName> <br /> <UnitPrice>3.5</UnitPrice> <br /> </qryPurchOrderAndDetails><br />- <qryPurchOrderAndDetails><br /> <PurchOrderID>2</PurchOrderID> <br /> <PurchOrderDetailID>3</PurchOrderDetailID> <br /> <ProductName>photocopy paper A4</ProductName> <br /> <SupplierRef>PCPA4</SupplierRef> <br /> <Qty>3</Qty> <br /> <UnitName>reams</UnitName> <br /> <UnitPrice>5</UnitPrice> <br /> </qryPurchOrderAndDetails><br /> </qryPurchOrdersAndSuppliers><br /> </dataroot><br /><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />When the data only is displayed in word it looks OK (unfortunately, I cannot display the tags that Word displays)<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec--><br /><br /><br />1<br />2007-03-17T00:00:00<br />Southern Veterinarian Supplies<br />?<br />countryvets001<br /><br />1<br />1<br />injection needles 10 pack<br />injneedl10pk<br />3<br />each<br />20<br /><br /><br /><br />2<br />2007-03-18T00:00:00<br />Hobart Office Supplies<br />office supplies<br />countryv01<br /><br />2<br />2<br />biros 5 pack<br />biros5pk<br />2<br />each<br />3.5<br /><br /><br />2<br />3<br />photocopy paper A4<br />PCPA4<br />3<br />reams<br />5<br /><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Hopefully it is clear that there is data from both the one side and the many side.<br /><br />When the xsl file that was generated is applied however, the many side data is lost<br /><br />Purch Order IDPurch Order DateSupplierNamePurch Order CommentSupplier Debtor Ref<br />117/03/2007Southern Veterinarian Supplies?countryvets001<br />218/03/2007Hobart Office Suppliesoffice suppliescountryv01<br /><br />So, I was wondering how to fix it. When I looked at the xsl file it jsut talks about the data from the one side, so I suppose I have got to alter it in some way.<br /><br />If somebody could give me a clue or two I would be muchly appreciative.<br /><br />Kind regards<br /><br />Ross<br /><br />
</div>
d="urn:schemas-microsoft-comfficedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PurchOrdersAllAndSuppliers.xsd" generated="2007-03-21T06:13:41"><br />- <qryPurchOrdersAndSuppliers><br /> <PurchOrderID>1</PurchOrderID> <br /> <PurchOrderDate>2007-03-17T00:00:00</PurchOrderDate> <br /> <SupplierName>Southern Veterinarian Supplies</SupplierName> <br /> <PurchOrderComment>?</PurchOrderComment> <br /> <SupplierDebtorRef>countryvets001</SupplierDebtorRef> <br />- <qryPurchOrderAndDetails><br /> <PurchOrderID>1</PurchOrderID> <br /> <PurchOrderDetailID>1</PurchOrderDetailID> <br /> <ProductName>injection needles 10 pack</ProductName> <br /> <SupplierRef>injneedl10pk</SupplierRef> <br /> <Qty>3</Qty> <br /> <UnitName>each</UnitName> <br /> <UnitPrice>20</UnitPrice> <br /> </qryPurchOrderAndDetails><br /> </qryPurchOrdersAndSuppliers><br />- <qryPurchOrdersAndSuppliers><br /> <PurchOrderID>2</PurchOrderID> <br /> <PurchOrderDate>2007-03-18T00:00:00</PurchOrderDate> <br /> <SupplierName>Hobart Office Supplies</SupplierName> <br /> <PurchOrderComment>office supplies</PurchOrderComment> <br /> <SupplierDebtorRef>countryv01</SupplierDebtorRef> <br />- <qryPurchOrderAndDetails><br /> <PurchOrderID>2</PurchOrderID> <br /> <PurchOrderDetailID>2</PurchOrderDetailID> <br /> <ProductName>biros 5 pack</ProductName> <br /> <SupplierRef>biros5pk</SupplierRef> <br /> <Qty>2</Qty> <br /> <UnitName>each</UnitName> <br /> <UnitPrice>3.5</UnitPrice> <br /> </qryPurchOrderAndDetails><br />- <qryPurchOrderAndDetails><br /> <PurchOrderID>2</PurchOrderID> <br /> <PurchOrderDetailID>3</PurchOrderDetailID> <br /> <ProductName>photocopy paper A4</ProductName> <br /> <SupplierRef>PCPA4</SupplierRef> <br /> <Qty>3</Qty> <br /> <UnitName>reams</UnitName> <br /> <UnitPrice>5</UnitPrice> <br /> </qryPurchOrderAndDetails><br /> </qryPurchOrdersAndSuppliers><br /> </dataroot><br /><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />When the data only is displayed in word it looks OK (unfortunately, I cannot display the tags that Word displays)<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec--><br /><br /><br />1<br />2007-03-17T00:00:00<br />Southern Veterinarian Supplies<br />?<br />countryvets001<br /><br />1<br />1<br />injection needles 10 pack<br />injneedl10pk<br />3<br />each<br />20<br /><br /><br /><br />2<br />2007-03-18T00:00:00<br />Hobart Office Supplies<br />office supplies<br />countryv01<br /><br />2<br />2<br />biros 5 pack<br />biros5pk<br />2<br />each<br />3.5<br /><br /><br />2<br />3<br />photocopy paper A4<br />PCPA4<br />3<br />reams<br />5<br /><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Hopefully it is clear that there is data from both the one side and the many side.<br /><br />When the xsl file that was generated is applied however, the many side data is lost<br /><br />Purch Order IDPurch Order DateSupplierNamePurch Order CommentSupplier Debtor Ref<br />117/03/2007Southern Veterinarian Supplies?countryvets001<br />218/03/2007Hobart Office Suppliesoffice suppliescountryv01<br /><br />So, I was wondering how to fix it. When I looked at the xsl file it jsut talks about the data from the one side, so I suppose I have got to alter it in some way.<br /><br />If somebody could give me a clue or two I would be muchly appreciative.<br /><br />Kind regards<br /><br />Ross<br /><br /></div>