Hello fellow forum members, We are facing a challenge in our multi-tenant SaaS application and are hoping for your expertise to find a solution. In our system, we use sequential numbering for entities such as debtors and invoices. It is crucial that no gaps or duplicate values occur in this numberi…

[image] How to achieve Unique, Sequential Numbers Reliably? Database boom A WORD OF WARNING THAT SOME OF THE SOLUTIONS PEOPLE OFFERED ABOVE ARE NOT RELIABLE AND YOU MAY, IN FACT, GET DUPLICATES OR WORSE UNLESS YOU USE THE FOLLOWING METHOD AS - I HAVE TESTED THEM ALL JUST L…

Seeking Assistance to Prevent Duplicate Values in Numbering

Need help Database

cmarchan January 2, 2024, 1:41pm 2