Is there a way to order a reference selection table by anything other than the ID. I use ninox to create attendance records and the attendance recorde has a reference to the list of students. When I click on the student item in the attendance form the student table that was referenced appears for me to select a student. I was able to create a constraint such that only active students appear, but I can't seem to find a way to order the students by their name instead of the default ID.
If in a view.. You can use an "Order by" clause.. If using the default table .. you can manually sort it once and it will stick.