Hi,

I need to dynamically build a form with dropdown boxes, that have been defined by the user. So there can be 1 or more drop downs, each with 1 or more options. The source data is being fetched from a database, so is in a flat (record set styled) structure.

For example I need to convert:
<rs:row FieldName="cars" Value="Volvo"/>
<rs:row FieldName="cars" Value="Saab"/>
<rs:row FieldName="cars" Value="Fiat"/>
<rs:row FieldName="Color" Value="red"/>
<rs:row FieldName="Color" Value="green"/>
<rs:row FieldName="Color" Value="blue"/>

Into:
<form>
 <select name="cars">
  <option value="volvo">Volvo
  <option value="saab">Saab
  <option value="fiat" selected>Fiat
 </select>
 <select name="Color">
  <option value="red">red
  <option value="green">green
  <option value="blue" selected>blue
 </select>
</form>

Now I know this is just the thing that XSLT is supposed to do, but I don't know how to do it....can anyone help?

Thanks in advance,
Brendon Smith.

Thanks, I'm going with the slow way suggested in the article, for now:

contact[not(surname = preceding-sibling::contact/surname)]

<xsl:apply-templates select="/records/contact[surname = current()/surname]" />