This might be an easy task but what I am wanting is to create a "Job Number" field that will automatically give a job a number based on the number I want.
Example. job number 10123, when i click new record i want the job number to automatically go to 10124, then 10125, 10126, etc. (10 is the year...next year will start 11001)
Can you help?
I'm using Filemaker pro 10 trial version.
Mac OSX (possibly transferring to PC soon)