So I have a couple of tables that I use to link deliverables to jobs and tasks to deliverables. Each line on these linked tables donโt really have a name that makes sense, so I use a number. Iโve used auto number reluctantly because itโs sort of a โdumbโ auto number. By โdumbโ I mean that it starts at 1 and increments from there. If I delete something out of the row, it picks up where the last increment was. If I delete something at the end of my list, now my nicely numbered rows are missing a number.
Iโd like to be able to start the auto number at an arbitrary number, and turn on an option to make sure that it is โsmartโ about the way it increments so that it looks at the last number currently in the table and adds 1 (n+1) rather than a simple (i++ ).