Custom Sequence Numbers (1 Viewer)

Pat Hartman

Super Moderator
Staff member
Feb 19, 2002
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?

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