AnsweredAssumed Answered

Auto Numbering

Question asked by CraigFiore on Mar 18, 2011
Latest reply on Mar 18, 2011 by CraigFiore


Auto Numbering



I am hoping I can get a little help with using FMP to automatically put in numbers. 

Here is my situation:

In one database I have a field called job numbers. They are written like this: 11-0012. What I would like to do is create a portal to another database to create ID Number like this: 11-0012 CO1, 11-0012 CO2, 11-0012 CO3....and so on. Not every job will a CO# and some will have one but other may have 8.

So, how do I do consecutive numbering based  on another field?

I hope I explained it correctly.