I am trying to do a similar thing, but I would like to number each reference number sequentially starting at 1 each time when the account number changes.  I am using for manufacturing though.  Each job will have operations open and within the query I want to number each jobs operation with a sequential number starting at one.  When the job changes then the numbering will begin again.  There is a sequence number for each job operation that sorts it, but it is different for each job so that field I believe can only be used to sort the numbering function.
I am using Windows 10 and Lightroom Classic CC.  Unlike many professional photographers who go on very specific shoots, when I travel, especially, I am shooting a wide variety of shots and in many different places.  Thus, I find it most convenient to import my photos into Lightroom with only the most basic information -- metadata, and general keywords.  Then when I have the time, I go through and sort the photos into subfolders, give them titles and more specific keywords.  I also want to number these photos.  Often, however, I will want to add more photos to a subfolder -- say my husband's photos taken at the same place.  In Photoshop, these photos can be numbered so that the numbering sequence follows the photos in the same folder that have already been numbered.
On the other hand, there are some disadvantages to changing from a sequential system. Suffixes are required when the same mile of highway contains multiple exits. Businesses and motorists have to adapt to the changes, and it costs money to replace the signs (as well as for temporary "old exit" tabs to ease the transition). Additionally, some argue that in the currently unlikely event the United States embarks on a metrication conversion, roads and exits would have to be re-numbered and re-measured anew. Ontario's Highway 401 changed to a mile-based system from a sequential system of exit numbers, then had to switch again to a kilometre-based system when Canada metricated in 1977.

Automata or finite state machines can typically be thought of as directed graphs, with edges labeled using some specific alphabet, Σ. Most familiar types of automata transition from state to state by reading input letters from Σ, following edges with matching labels; the ordered input for such an automaton forms a sequence called a word (or input word). The sequence of states encountered by the automaton when processing a word is called a run. A nondeterministic automaton may have unlabeled or duplicate out-edges for any state, giving more than one successor for some input letter. This is typically thought of as producing multiple possible runs for a given word, each being a sequence of single states, rather than producing a single run that is a sequence of sets of states; however, 'run' is occasionally used to mean the latter.


An overwhelming majority of companies use designation-based part-numbering systems. A Design Management Procedure, for example, may be numbered as SOP 4.4-1. With the previous revision of the ISO 9001 standard, it meant that this document related to the element 4.4, design management. Well, it does not mean the same with the new ISO 9001 revision, simply because design management clause now has a different number: 7.3. What is the solution? The solution is simple: no part numbers, and no designators! raffle ticket numbering
×