I am very new to XML and I am having trouble getting my head arround the idea of transfering the XML Heirachy into a SQL DB.

I have code that will update a table in a database by setting the XML up as a recordset then looping through it.
However my XML doc has a heirachy and child nodes should be in a different table to the parent node.

Does anyone know of any links that explain this area of XML and Database updates. All the examples I have read show a simple one table scenerio.

I am using VB6 though my background is in ASP.

Any pointers and links would be much appreciated.

Rod

__________________
======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================