I have an access db and the db has two tables "parent" and "parent_case". I would like to export data from these two tables into xml. I did the export and unchecked opition "include primary key or index" in the schema tab, but somehow the primary id is repeated in the patient_case part, how can I get rid of this? In addition, with the xml data file, instead of saying "dataroot" at the top, I would like to rename it something else like "qic_parent". the follwoing is the xml data file:
<?xml version="1.0" encoding="UTF-8" ?>
- <dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="parent.xsd" generated="2012-01-11T08:16:34">
- <parent>
<parent_id>11111</parent_id>
<address>999 abc st</address>
<phone>7039999999</phone>
- <parent_case>
<parent_id>11111</parent_id>
<lastname>Doe</lastname>
<firstname>John</firstname>
</parent_case>
</parent>
- <parent>
<parent_id>22222</parent_id>
<address>888 abc st</address>
<phone>7038888888</phone>
- <parent_case>
<parent_id>22222</parent_id>
<lastname>Jane</lastname>
<firstname>Mary</firstname>
</parent_case>
</parent>
</dataroot>
thanks,
Bonzai