Incrementing text fields

[Pedro]

Hello folks,

I have a big problem with my FM solution. I have a text field that must be a caracter. I have to auto-increment this field when a new record is inserted.

Exemple:

The first record is A, the second is B , the tird C ......

Can you help me?:

Thanks.

[LiveOak]

So what is the 27th record? If you just want A..Z to repeat, you can do this with a serial number field and a calculation.

SerialNum (number, autoenter serial number, 1, 1)

Letter (calculation, text) =

Middle ("ZABCDEFGHIJKLMNOPQRSTUVWXYZ", Mod (SerialNum, 26) + 1, 1)

-bd

[djgogi]

Hi ,

here's the file I've recently created reguarding this problem

ftp://ftp.fmfiles.com/download/devhaven/devhelp/Alfa.fp5.sit

Dj