Keep database sorted by one field
I have a database of accounts that I run on a vending route. I need to keep them in order that I service the machines. I have done this by using a "STOP" field, and number them in the order they should be serviced.
My problem.. everytime I view the database they are all out of order. I have used the "sort assending" over and over I have also defined the field to Keep field STOP sorted in assending order. when I open it up again it is again unsorted.