Selecting an Attribute Based on Conditions of a Subsequent Node

I am trying to select an attribute from a list of nodes that is conditional 
based on the contents of a node below it.

Here is the sample XML:

<?xml version="1.0" encoding="UTF-8"?>
<Account>
        <NodeName Name="Acme">
                <NodeType Value="Primary"/>
        </NodeName>
        <NodeName Name="Widget">
                <NodeType Value="Secondary"/>
        </NodeName>
</Account>

What I want is to select @Name from NodeName based on the @Value attribute in 
the NodeType element.  In other words, I want to determine which @Name 
attribute is Primary and which one is Secondary.  This XML is generated out of 
a database so its format is not very good and not always sorted.  This prevents 
me from doing this based strictly on position.

Any suggestions?

Thanks,
Jim


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list