Logic issues in asp+mysql

[reerfanty]

I have a logic problem.I have some clients, in a MySQL database table.The client number is the primary key.Here are some examples of client numbers (ex: 10127, 8520053).I'm using asp and I want to insert this in a table(array) and use the client number as the index.Like you may noticed 8520053 is to big for a table and makes an out of memory error.I'm trying to find a formula or whatever you can suggest that can make the client number unique and small enough to fit in a table(array) to use as an index.I also have the client number in other tables so that formula has to work from table to table.Any help would be greatly appreciated!!