Stephanie, > On Jul 22, 2020, at 3:28 PM, Stephane Potvin via 4D_Tech > <[email protected]> wrote: > > I have a database for organizing my printed music collection. > > I use a folder numbering system to do so, using this format: Letter-number > i.e. A-25, A-26, B-17, B-18, etc. > > I have one field for the letter and one field for the number. > > To make it easy, I use the method below to automatically fill the number when > I enter a letter. > If I enter the letter A, the number will automatically fill the number with > 27 if the last one in existence was 26 for the letter A. > It behaves fine for single letters and combinations: AB, ED, etc. > > Everything works perfectly well except when I enter the letters CH. > When I do the number field gets the value 207119, and up, whereas it should > currently be CH-271 > > I need your help figuring our why it behaves this way only for those letters.
Just for sanity’s sake, did you check if you have a record with a [Repertoire]Folder number of 207118? Randy Kaempen Intellex Corporation ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
