I am developing a faq stored in a xmlfile. The faq has several main categories, in every main categories there might be none or several subcategories. I am trying this...
<?xml version="1.0"?>
<faq>
<language>
<languageId>EN</languageId>
<category>
<categoryId>1</categoryId>
<categoryName>Search</categoryName>
<subCategory>
<subCategoryId>1</subCategoryId>
<subCategoryName>Search subcategory1</subCategoryName>
<faqQuestion>
<question>What happens if..?</question>
<answer>Nothing..</answer>
<visible>true</visible>
<dateCreated>2005-09-15</dateCreated>
</faqQuestion>
</subCategory>
<subCategory>
<subCategoryId>2</subCategoryId>
<subCategoryName>Search subcategory2</subCategoryName>
<faqQuestion>
<question>How can I..?</question>
<answer>Do like this..</answer>
<visible>true</visible>
<dateCreated>2005-09-15</dateCreated>
</faqQuestion>
</subCategory>
<faqQuestion>
<question>If I want...</question>
<answer>Click on..</answer>
<visible>true</visible>
<dateCreated>2005-09-15</dateCreated>
</faqQuestion>
</category>
</language>
</faq>
I get the answer (.net) "The same table (faqQuestion) cannot be the child table in two nested relations."
Can anyone help me how to get a working structure on this xmlfile?
<?xml version="1.0"?>
<faq>
<language>
<languageId>EN</languageId>
<category>
<categoryId>1</categoryId>
<categoryName>Search</categoryName>
<subCategory>
<subCategoryId>1</subCategoryId>
<subCategoryName>Search subcategory1</subCategoryName>
<faqQuestion>
<question>What happens if..?</question>
<answer>Nothing..</answer>
<visible>true</visible>
<dateCreated>2005-09-15</dateCreated>
</faqQuestion>
</subCategory>
<subCategory>
<subCategoryId>2</subCategoryId>
<subCategoryName>Search subcategory2</subCategoryName>
<faqQuestion>
<question>How can I..?</question>
<answer>Do like this..</answer>
<visible>true</visible>
<dateCreated>2005-09-15</dateCreated>
</faqQuestion>
</subCategory>
<faqQuestion>
<question>If I want...</question>
<answer>Click on..</answer>
<visible>true</visible>
<dateCreated>2005-09-15</dateCreated>
</faqQuestion>
</category>
</language>
</faq>
I get the answer (.net) "The same table (faqQuestion) cannot be the child table in two nested relations."
Can anyone help me how to get a working structure on this xmlfile?