how do I make groups/subgroups view in alphabetical order in admin section

Hi Dave,

Inside the "inventory" section, the field "model" has the following parameters:

display - pull down (single)

list - Get options from MySQL query (advanced) and the code Chris installed in the box there is:

SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>model`
WHERE manufacturer = '<?php echo $ESCAPED_FILTER_VALUE ?>'

and then Advanced Filter, refresh list when this field changes - "manufacturer"

Let me know if you need anything else. You may or may not need to know is that there was a custom plugin installed on this site by Chris (prior to the following release) that enabled an ability to work across the tables for some functionaility. Let me know if you want me to email ftp/admin access off list.

Hi Terry,

Thanks! Try adding this code (in red):

SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>model`
WHERE manufacturer = '<?php echo $ESCAPED_FILTER_VALUE ?>'
ORDER BY title

Let me know if that works for you.

Dave,

that did the trick! Thank you EVER SO much!