Custom Sequence Numbers

[Pat Hartman]

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

 

[Pat Hartman]

New version. Not much difference. Just a little cleanup.

OLD ---- scroll down for newest.

 

[Gasman]

@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?

 

[Pat Hartman]

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.

 

[Pat Hartman]

Sorry, forgot to upload the updated version.