piskie

I need to generate a list of ALL the values contained in the field called "type" from a Table but with each particular value (or "Type") only appearing once in the list. This is to be built up by a repeat region in a temporary recordset.

I can produce a Temporary Recordset OK, but each entered value in the "type" field will appear multiple times. How do I make it so that each value for type only appears once to produce a set of links like:

<a href="select.php?type=saloon">Saloons</a>
<a href="select.php?type=coupe">Coupes</a>
<a href="select.php?type=mpv">MPVs</a>

etc


Any guidance would be much appreciated.