select the parent list in design view.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


