I want a unique clientnumber for each client.
I also have departments.
The format I need is as follows:
Department-code = 2 numbers
autonumber = 6 numbers
So the whole code must be unique, but it is possible to have more than 1 of the same autonumber.
Is this possible? I was looking at http://www.experts-exchange.com/Databases/MS_Access/Q_11726758.html
but it doesn't seem as easy for me.