Thank you Pat,
We have been in business for quite a while and our pricing of all our stock is related to these existing codes LS1, LS2 etc etc.
As you could imagine, relabelling thousands of items of stock is simply not a solution! I will not be using this code in Access as a PK as I...