Auto number in a replica database ?

[baye]

I have just replicated a database and hence the field I used as the record identifier (customer No. in this case)was changed to 'random'and 'Long integer' field values.
I would like this number to be a four or five digit number and of a positive value is there anyway I can do this. As the number now is to long and uses negative values.
Any help would be very much apprehicated.
thanks

 

[thegman]

if you are using something along the lines of MySQL or another SQL-style database, you could make an auto_increment field for your Customer no. This would make the numbers start at 0 and go up by themselves as customers were added. To make the number always be 4-5 digits, it really depends on what type of tables you are using how easy that would be.

 

[baye]

thegman,
Thanks for your help I'll try your sugestion and see how I go.

Thanks Again...