I am trying to solve and old problem.

I am creating a folio numbering system based on monthly jobs. I have
currently got a date field which shows estimated time of arrival for the
job. From that i use the calculation "Right( Year(DateETA ); 2 )&Right (
Month( DateETA); 2 )" in my Folio field to get it to show year and month. eg
0611. Once the folio number is created it must be unchangeable.

I will have up to a 999 jobs per month and wish it to show the number of the
job in the folio number. eg. 0611001 to 0611999. The date of arrival is not
important just the number of the job.

It would have to reset each month eg 0612001 .

This folio number is also concated with 2 other fields to make a Bill of
lading number and also it is used to form the basis for a catolog system.

It is also exported as the job number with invoice details etc for various
accounting systems. eg Quick books and MYOB accounting.

If anyone can help it would be appreciated.