Insert a record in a serialized number field, and increment the following recors by +1
Is there such a thing as a serialized field that allows to "insert" a record in the numbered order and and increment the following records by +1?
I am trying to build a database for slides to be used in presentations. Ideally, the default sorting order would be dictated by a narrative order defined by me as I add new records. Therefore, no chronological or alpha-numerical order is convenient. I am currently attributing numbers by hand to each slide according to their place in the rather organic order, but it is very burdensome. I would like to simply create a new record where it belongs in the order I have deermined. Any ideas?