creating unique number
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