3 Replies Latest reply on Apr 11, 2012 8:53 AM by gowa

    Customer Number (Serial)

    gowa

      My boss would like all new and existing customers to have a customer number.

      I created a serial but it does not work the way I want.

      It only works for new additions but not the existing customers in the database.

      I'm a newbie.

      Can someone help me with this?

      Many thanks.

        • 1. Re: Customer Number (Serial)
          ariley

          You'll have to re-serialize your records. You can use the Replace Field Contents command for that. Make sure you start your serial number from 1 (if you just want a number) and apply auto-increment 1. 

           

          agnes b. riley . filemaker and web development

          FileMaker Business Alliance . FileMaker Technical Network

          www.zerobluetech.com (http://www.zerobluetech.com)

           

           

          T 201-299-6223 (NJ) .

          212-842-8830 (NY)

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

          .

          917-660-7221 (C)

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

          FileMaker Certified in 10 and 11

          people + products + events + todos + invoices + documents = productivity

          1 of 1 people found this helpful
          • 2. Re: Customer Number (Serial)
            TimGriffith

            What she said is correct, plus check the box 'update serial number in entry options'. This will make it that the new records will have the continuing serial number.

               The serial number can be applied to a text field also, but you will find that sorting behaves differently (you get results like 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 100, 101...). To overcome the sorting issue in text fields, pad the serial number with zeros (00001 for example). The 'Replace Field Contents' command will preserve the padding. However, with a text field and zeros padding you must deal with real world issues such as 'did I pad enough zeros?'- how many customers do I expect over the life of the program?

            1 of 1 people found this helpful
            • 3. Re: Customer Number (Serial)
              gowa

              Thank you, Agnes & Tim.