Yes, there is one (and only one) event with many actions in a single XML file.
Unfortunately, I cannot provide the files. But, they basically looks like this (stripped down and simplified):
<event><name>...</name>
<category type="...">...</id>
<action>
<field1>...</field1>
<field2>...</field2>
...
</action>
<action>...</action>
...
</event>
The XSLT looks something like this:
<xsl:template match="/"> <event_table>
<name><xsl:value-of select="name" /></name>
<type><xsl:value-of select="category/@type" /></type>
<category><xsl:value-of select="category" /></category>
<xsl:for-each select="action">
<event_table>
<field1><xsl:value-of select="field1" /></field1>
<field2><xsl:value-of select="field2" /></field2>
</event_table>
</xsl:for-each>
</event_table>
</xsl:template>
The problem is that none of the fields are unique within the event to be able to distinguish events from one another or create a reference between the event and its actions. I've looked for a way of generating a surrogate key between the two, but I'm not sure how to do that using only the XSLT. I'd also be completely fine if the solution required some sort of scripting, but I'm not at all familiar with Access scripting capabilities on how to accomplish the task.
Thanks.