click the dynamic button in the property inspector.
you currently have the value set to use the brand column, set the value to use the brand ID column.
Thanks, Jason -- I was getting punchy yesterday. Got the dropdowns working.
Still have a small issue. The following is the script output from the dynamic array
<SCRIPT>
var WAJA = new Array();
WAJA[0] = new Array();
WAJA[0][0] = 'Nathan|WA|s';
WAJA[0][1] = new Array();
WAJA[0][1][0] = '1';
WAJA[0][1][1] = 'Ham';
WAJA[1] = new Array();
WAJA[1][0] = 'Field';
WAJA[1][1] = new Array();
WAJA[1][1][0] = '2';
WAJA[1][1][1] = 'Bologna';
WAJA[1][2] = new Array();
WAJA[1][2][0] = '3';
WAJA[1][2][1] = 'Hot Dogs';
WAJA[1][3] = new Array();
WAJA[1][3][0] = '4';
WAJA[1][3][1] = 'Test';
WAJA[1][4] = new Array();
WAJA[1][4][0] = '5';
WAJA[1][4][1] = 'Test';
WAJA[1][5] = new Array();
WAJA[1][5][0] = '6';
WAJA[1][5][1] = 'Test';
WAJA[1][6] = new Array();
WAJA[1][6][0] = '7';
WAJA[1][6][1] = 'Test';
WAJA[2] = new Array();
WAJA[2][0] = 'Nathan|WA|s';
WAJA[2][1] = new Array();
WAJA[2][1][0] = '8';
WAJA[2][1][1] = 'Hot Dogs';
var products_WAJA = WAJA;
WAJA = null;
</SCRIPT>
As you can see the ' in Nathan's doesn't output -- instead |WA| is in its place. I've tried setting the column data type as text, varchar, and tinyblob with no success. I need the ' in the name.
Any suggestions?
Mike