This content has been marked as final. Show 1 reply
Sounds like your Getting unique numbers for one numberseries (table)?. As far as Filemaker is concerned, unique is unique. Perhaps you can require NumberField A to start with the content of NumberField B. Even better if you switch NumberField B to a letter, which gives you 26 groups instead of 10. Then, you could set NumberField A ( now changed to text) to be unique, as A101 would be different than B101.