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

Hi equinox69,

How is the 'model' field setup in the field editor?

Specifically, what is "List Options" set to?

Let me know and I'll see what I can come up with.

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.