Passing A Variable to the Serial Number Function

[TattyDon]

I have a invoice table with a unique ID. In the same table I have a field for invoice reference number. What I'd like is to have this populate as a default with a sequential number. That bit is dead easy - I could just use the auto serial function.

However, I'd like the number to be made up of the first letters of the jobcode plus the serial numbers. (The jobcode is stored elsewhere). This means that a group of invoices would be say HM0012 and another might be GH0001.

Maybe on loading the sheet I need to auto populate it with the serial number (0012) and then run a script which adds the first two letters of the jobcode to it... is that the best way?

Thanks

John

[IdealData]

Make another calculation field that concatenates the job code and serial number fields.