Hi hope someone can help as my head is now tangled with this one which shouldn't be causing me the headache it is...here goes

I have to flatten my data as i am putting it into database...the structure is something like this

<tag1>
<child1oftag1>
<child2oftag1>

<tag2list>
<tag2>
<child1oftag2>
<child2oftag2>
</tag2>
<tag2>
<child1oftag2>
<child2oftag2>
</tag2>

</tag2list>
<tag3list>
<tag3>
<child1oftag3>
<child2oftag3>
</tag3>
<tag3>
<child1oftag3>
<child2oftag3>
</tag3>
</tag3list>
</tag1>

my xslt currently looks like this
<tag1>
<child1oftag1>
<child2oftag1>
<xsl:for-each select="tag2List/tag2">
<tag1child>
<tag><tag>etc...and the same for secondlist..hope this makes sense

basically what i need is to creat a single row of data for each taggroup within the list tags..eg for every tag2 within tag2list create row which includes the childoftag1..etc..
then i do a selectnodes loop through attaching them to variables and insert into database...but its not working quite right...has anyone any better suggestions...

cheers for any help..

ang