Sometimes sorting on ID, or name (or any other field) is not sufficient and a separate sorting order is necessary.
Adding logic to both table and form to handle the extra sorting column is desirable :
in a table :
- specifying the sorting column, results in sorting to the values in that column
- tool to change the order, by f.e. using up or down buttons. in a form :
- add a 'order' field, that contains logic to change the values in the order column of other rows, after choosing a new place in the order for a row.