I have a db that I want to add a customer number field to a table in a db. However, there are already many exixting customers to do one at a time. I want to create unique numbers for each one. An example would be 6516f6511r100000. Then, each one thereafter would increment by one. In addtion, each new entrant would auto-increment. Can anyone help with this?