1 Reply Latest reply on Dec 20, 2009 5:40 AM by StellaLuna

    creating unique number

    Ikyzume

      Title

      creating unique number

      Post

      Hi, guys. I home someone can help me.

      I'm working with FM pro 8.5. I've to generate an automatic unique number for a specified field. as in the layout i've the automatic date, i thought to auto-create a "serial number" with the number sof the date and the record number, so to have a unique serial in the whole database. for example, if today, 20/12/2009 i create the 45th record, i would like to get automatically the number 2012200945. i've tryed many solutions but i can't find the "record number" in the calculation options and i don't know how create either the first number as 2012009.

      thanks to all for tips 

        • 1. Re: creating unique number
          StellaLuna
             Use a worthless auto-enter serial.  Any time you include meaning into a serial, it will be big problem down the road.  filemaker has perfect solution.  Go to the IDs auto-enter table and click 'serial' and increment by one. :smileyhappy: