ExportXML Problems

J

Jim Murray

I'm exporting data to an inflexable XML format. I have 3 nested tables linked
by a primary key. When I use the ExportXML function it sends the primary key
with each table. Is there a way to remove the key (CaseID) from the XML
export of the nested tables? For Example:

- <case>
<CaseID>106618</CaseID>
- <main>
<CaseID>106618</CaseID> - - - (Remove)
<M_AttID1>1389</M_AttID1>
</main>
- <charge>
<CaseID>106618</CaseID> - - - (Remove)
<C_Statute>14:25</C_Statute>
</charge>
</case>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Access 2003 - ExportXML Method 0
ExportXML won't nest properly 0
Design for multiple Unions 6
import xml not a problem, setting key for subtables is 1
ExportXML with Filter not working 0
Improving Nested Formula Calculation Efficiency 2
How to define relationships in XML schema? 0
Relationship Help with Tables 1

Top