I have added a dropdown to the detail_cr and it defaults to alphabetical order. Is there a way to order the dropdown by the "id" column for this table?
On the few custom tables that I've created they defaulted to displaying ID in numerical order. I added a .mod file to my system with the syntax to force it to order by the sym attribute. You could use a similar approach, but I'm wondering why it's different for you.
Add this to a .mod file and place in nx_root/site/mods. You'll need to update the object and factory to match your environment.
WHERE "delete_flag = 0" ;
Edited, didn't save correctly.
Should this be added directly to the detail_cr.htmpl or should it be it's own file in the root of mods? If it is it's own file, how does the detail_cr.htmpl know to reference that file?