Creating Alpha Numeric Unique field for each client with different 3 word
i desperately need help regarding to Build the data Base
we have 5 clients and i have to create a Unique Alpha numeric Character as a unique ID for sorting and searching, its primary key.
1- All the 5 client, i have to use 3 characters which is difference.
2- All the numeric value would be fine by incremental 1 but if i am selecting the other client which got the 3 different word ( i.e - coke for Coc, Nestle for Nes) how i have to define value so when i am on coke or nestle, it start from 1 and if we have in one client 50 record and other one got 90 record and some one come over and want to add new record its add 51 or 91. please help.