Custom Sequence Numbers (1 Viewer)

Pat Hartman

Super Moderator
Staff member
Joined
Feb 19, 2002
Messages
44,115
Two examples of a custom sequence number. One is a complex ID with concatenated parts. The other is just a sequence number for detail items and is not used as a PK. It has a renumber feature.

See below
 
Last edited:
@Pat Hartman
Just had a peek to see what the code looked like. :)

I ran the query directly choosing SalesID of 4, and got this result?
Is that intentional, as I would have expected the numbering to be as per entry into the table, as shown by DetailID number?

1677095066459.png
 
That's the original data. You would need to change one of the item numbers to see the sequence change. Change the 10 to 100. Resequence and the ten will move to the end and be number 40.
 

Users who are viewing this thread

Top Bottom