Export to xml: Table is shown twice

[Nina07]

Hello,
I have a problem with an export to xml.
The picture below show the problem.
When I want to export my tables to xml, I start with "Hoofdgroep". The problem is that "Subsubgroep" is shown twice.
And when i take a look at the exported xml I see that data is not correct.
What I want is that under Hoofdgroep ID 1 and SubgroepID 1 only the data of subsub 1.1.1 and 1.1.2 and 1.1.x... is shown

I Hope this makes any sense and that someone can help me.


If you need more information you can just ask.
Thans in advance.

[amrut]

I think this has something to do with your table relationships. There are many One-To-One relationships and many primary keys in a table which is unusual. The table "Subsubgroep" and "subgroep" have two fields related to each other.That may be the reason. Looking at the table relationships, I think there is something seriously wrong with your table relationships or I am completely wrong !!
You can go through these links https://support.microsoft.com/en-us/kb/304466/ and https://support.office.com/en-NZ/Art...3-0d3926086687

[Nina07]

Thank you for your reply. I have attached an other image so you can see what the data looks like. Maybe this way all the links make sense. we made the links like this so that evere item in "subgroep" shows up in the correct "hoofdgroep" (every "subgroep" with "hoofdgroepID" 1 shows up under "HoofdgroepID" 1) the same goes for subsubgroep: every subgroep with HGID 1 and SGID 1 goes under SG 1.1
Also there are 3 links going from "subsubgroep" to "subsubgroepartikel" and here the data in the xml is showing up fine for this relation.

[amrut]

Looking at your data from above three tables, if they are PArent. Child and Grandchild, then your relationships are incorrect. Follow the principle that all tables to have one primary key ( i am refering to related fields only. If your business model requires more, I can't say about it). Each Parent's Primary key is related to it's child table to a field which is not primary key.