On 16 Oct 2016, at 12:32am, Keith Medcalf <kmedc...@dessus.com> wrote:
> The whole reason for using a "manual sortation field" is so that a human can > decide what order to display the data in via a "manual" operation. You answered the question. To get as close to the OP's requirements as possible the order needs to be governed by two fields, an ID field and a SortOrder field. The SortOrder field can default to 1. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users