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)
The simplest method is to select the AUTO-ENTER option in the table set up screens. Select SERIAL NUMBER. For the next number select 10001 (or whatever you want the next number to be. Next year reset it to 11001. It will default an increment of one. You can change on when it will increment, on creation or on commitment of the record.