creating a custom invoice/tracking number
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:
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?