I am entering data into a field on a continuos form.
I am trying to create a reference number in a field that is basically the two digits from the current month and an incrementing number starting at 1. The increment must start at 1 for each new month and year.
This is to automate a File reference number so that when a customer is entering supplier purchase invoices they like to file the purchase invoice in monthly order. this reference number is then phisically hand written on each purchase invoice and is a number that allows users to find purchase invoices quickly in the filing cabinet. So all purchase invoices will have a ref for example a June invoice might be 06 12. That will be placed as the 12th invoice in the file for June. But I also need to make sure that when incrementing that the increment does not pick up last years June and increment from that largest number.
Whats the simplest way to do this?