How do I create a unique sequential number for each record (@Number)?
You can use @Number, as you do in Q&A. But in Sesame there is only one @Number per application, which can contain several databases. You can also use variables to get multiple @Numbers. And you can also use the handy technique of adding one to the highest existing number in that field with programming like this … IF Number1 = “” THEN Number1 = @ToNumber(@XLookupR(@Filename, 99999, “Number1”, “Number1”)) + 1 The field that Number1 is bound to MUST be a number field. This is easy to copy to other fields, you can use it in as many fields as you want, and requires no “@Number maintenance”.
Related Questions
- I entered a contact that should have had its own unique company record number; instead, I assigned it to an existing company. How do I create a new company and transfer this contact and all related activities to the new company?
- Style Record Q) What happens if I create a User Style pointing to User Programs, and then load a different set of User Programs to the same locations?
- How do I create a unique sequential number for each record (@Number)?
