Thank you Ray.
is there a way to drop this into a repeat region? I've tried the following but, whilst it does give me a dynamic list it auto loads on the last value:
<?php
while(!$rsDISTILLERY->atEnd()) {
?>
<option value="<?php echo($rsDISTILLERY->getColumnVal("wbprodDISTID")); ?>" <?php if (!(strcmp($rsDISTILLERY->getColumnVal("wbprodDISTID"), $rsDISTILLERY->getColumnVal("wbprodDISTID")))) {echo "selected=\"selected\"";} ?>><?php echo($rsDISTILLERY->getColumnVal("wbprodDISTILLERY")); ?></option>
<?php
$rsDISTILLERY->moveNext();
}
$rsDISTILLERY->moveFirst(); //return RS to first record
?>