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.