AnsweredAssumed Answered

Help with a format...

Question asked by jbrad1968 on Dec 19, 2011
Latest reply on Feb 1, 2012 by jbrad1968

I have a database with a field named "CaseNumber" and I need it to format it like GC11-12-001 This represents "GC" as my county abbreviation and "11" as the year (2011) the "12" is the month (Dec.) and the "001" is the first case of that month. I need the field to increase by one for every new record. ie: GC11-12-001, GC11-12-002, and so on...And start over when the next month starts. But when the year changes the "GC11" needs to change to "GC12" and when the month changes I need it to change from "GC12-01-xxx" to "GC12-02-xxx" when it becomes Feburary in 2012. I cannot for the life of me figure out how to make FM pro 10 do this. I would appreciate any and all help...

 

Example: In January of 2012 it should start GC12-01-001 then the next record would be GC12-01-002 and so on until Feburary then it should go to GC12-02-001...

 

It would be the greatest if i could just type 001 in the field and it format it when you tab out....

 

Thanks for any help....

Outcomes