incrementing a number based on a FIND

[the_moto]

I am trying to setup an automatic invoice numbering script. The invoice number is made up of the job number and the invoice number. (eg "JOB01-01". the next invoice in this set would be "JOB01-02") So I'm trying to increment the second part of this invoice number.

What I've been trying...unsuccessfully:

I do a find on the JOB number, get the count with "Status(CurrentFoundCount)", take that number and add 1 to it "Status(CurrentFoundCount) + 1" and then concat this incremented find count for the JOB number to the JOB number.

JOB number & Status(CurrentFoundCount) + 1

I can't get filemaker to do it. HELP.

What am I doing wrong.

I've tried making a calculation field that gets the found count but that isn't working either.

Thanks-

Mike

[SteveB]

It looks like Job # is text, not numeric. Use the NumToText(Status(CurrentFoundCount)+1)

[RussBaker]

Just to amplify Stevinvegas' answer a bit... This will tidy up the appearance of the rightmost digits, using a Job_Number text field which, I assume, currently contains something like "JOB01" for a job.

JOB_Invoice_Number = Job_Number & "-" & Right("00" & NumToText(Status(CurrentFoundCount)+1),2)