I need 1 serial number made up of 4 fields - is this possible?
I need to have one number for a small museum collection that is made up of four fields. I can not make this work.
The First field would always be the same - SA; the second filed would be the four digit year that the item was acquired - 2002; the third field would be a four digit Serial number - .0001; the fourth field would be a "sub field that would be three digits - .001
When put together, the number would be something like this: SA.2002.0034.002. The third field would represent the Deed of Gift number and the fourth field would be the item number for that donor gift.
Can anyone tell me how to do this? Many thanks for your help.