AnsweredAssumed Answered

creating a custom invoice/tracking number

Question asked by BenHerrera on Sep 18, 2013
Latest reply on Sep 18, 2013 by philmodjunk


creating a custom invoice/tracking number


     Hi all,


     I am new to FM. but savvy enough to break things and fix it. I just can't wrap my head around this... 


     I need to create a custom number for every new record... an internal tracking No. that needs to be formatted like:  


     example:  2013OVB-1  


     there doesn't need to be a zero place holder preceding the "1".


     this number is going to be related to every record in the DB. There are 4 tables in the DB that will use this number. It will be unique to every record. regardless from which table the record is generated from, I need the number to be sequential?


     any thoughts