Recordset problem

[birney29]

Hi! my problem is this, I have an XMl document containing 2 people, tis is the loaded into a recordset. i wish to display in an HTMl table the persons "status History" this may be multiple historys as you can see from the XML below:

<?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?>
<?xml-stylesheet type=&quot;text/xsl&quot; href=&quot;ApplicationDetailsApplicant.xsl&quot;?>
<details>
	<ApplicationDetailsApplicant>
		<SequenceID>1</SequenceID>
		<ID>3676.000000</ID>
		<ApplicationType>Shotgun</ApplicationType>
		<CertificateNumberLabel/>
		<Status>46.003000</Status>
		<Reason/>
		<DateReceived>01/05/2001</DateReceived>
		<DateAccepted/>
		<DateAppliedFor/>
		<Comments>1057</Comments>
		<AppealLodged>false</AppealLodged>
		<AppealUpheld>false</AppealUpheld>
		<AppliedForCoterminous>false</AppliedForCoterminous>
		<NameLabel>Willy Jackson-Brown</NameLabel>
		<DateOfBirthLabel/>
		<AddressLabel>132, Any Old Way, Edinburgh, Lothian</AddressLabel>
		<StatusBox>
			<SharedBy>
				<StatusDateLabel>12/03/2002</StatusDateLabel>
				<StatusLabel>Application Received</StatusLabel>
				<StatusReasonLabel/>
				<UserLabel>guest</UserLabel>
			</SharedBy>
			<SharedBy>
				<StatusDateLabel>12/03/2002</StatusDateLabel>
				<StatusLabel>Application Received</StatusLabel>
				<StatusReasonLabel/>
				<UserLabel>guest</UserLabel>
			</SharedBy>
		</StatusBox>
	</ApplicationDetailsApplicant>
	<ApplicationDetailsApplicant>
		<SequenceID>2</SequenceID>
		<ID>3673.000000</ID>
		<ApplicationType>Firearm</ApplicationType>
		<CertificateNumberLabel/>
		<Status>46.003000</Status>
		<Reason/>
		<DateReceived>12/12/2001</DateReceived>
		<DateAccepted>15/02/2002</DateAccepted>
		<DateAppliedFor/>
		<Comments/>
		<AppealLodged>false</AppealLodged>
		<AppealUpheld>false</AppealUpheld>
		<AppliedForCoterminous/>
		<NameLabel>Willy Jackson-Brown</NameLabel>
		<DateOfBirthLabel/>
		<AddressLabel>132, Any Old Way, Edinburgh, Lothian</AddressLabel>
		<StatusBox>
			<SharedBy>
				<StatusDateLabel>15/02/2002</StatusDateLabel>
				<StatusLabel>Approved</StatusLabel>
				<StatusReasonLabel/>
				<UserLabel>guest</UserLabel>
			</SharedBy>
			<SharedBy>
				<StatusDateLabel>15/02/2002</StatusDateLabel>
				<StatusLabel>Application Received</StatusLabel>
				<StatusReasonLabel/>
				<UserLabel>iplanet</UserLabel>
			</SharedBy>
		</StatusBox>
	</ApplicationDetailsApplicant>
</details>

i can display the first status item using:

<xsl:for-each select=&quot;SharedBy&quot;>
  <tr>
    <td width=&quot;25%&quot;><span  datasrc= &quot;#xmlData&quot; datafld=&quot;SequenceID&quot;></span></td>
 <td width=&quot;25%&quot;><span datafld=&quot;StatusLabel&quot;></span></td>
 <td width=&quot;25%&quot;><span datafld=&quot;StatusReasonLabel&quot;></span></td>
 <td width=&quot;25%&quot;><span  datafld=&quot;UserLabel&quot;></span></td>
</tr>
</xsl:for-each>

Please help!!
Kenneth Birney
User Interface Programmer
Scottish Police