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++ ).
... View more