AnsweredAssumed Answered

Creating Alpha Numeric Unique field for each client with different 3 word

Question asked by ShoaibAhmed on Jul 28, 2011
Latest reply on Jul 28, 2011 by philmodjunk

Title

Creating Alpha Numeric Unique field for each client with different 3 word

Post

HI All


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.



thanks

Outcomes