Hello
I have a requirement where I want to create a Unique Customer ID based on their name and an incremented number
For example:
I add a new customer "XYZ (North)" and want to generate the Customer ID XYZ001
Then I add another New customer "XYZ (South)" and want to generate the Customer ID XYZ002
ID would just increment for each 3 character prefix. I have no problem with having another table to trank the highest used number for XYZ if needed
Fields would be "Customer Name" and "Customer ID"
TIA
Mike
