Is there a way I can generate an Auto-Enter Serial Number based on another fields value. I have 3 warehouses that I use to store client freight in. Each warehouse is in a different state. I have a field setup that is not a primary key that I use to generate a unique Auto-Enter Number for each record. If the item is located in state A, I'd like the number to start with an”A”, If state B “B” and so on. I see an option to enter a calculated value, but I'm too new at this to figure it out. Any help with this would be greatly appreciated.