Not sure how to fix this problem- Id number

[runsh]

How can I chage the Id#'s lengh.
when an item is enter it generates an Item Id such as this one #50034822521100004.
Is there any way I can change this long number to 6 or 7 digits. I tried to change Text in database to number field got error. tried to change field to 7 or 10 instead of 50 got error. can not change to autonmuber becase table already has autonmuber.
Not sure how to fix this problem

any idea!
thanks

 

[guitardave78]

How are you generating the ID?
the # means you cant change it to a number field.
if it is ASP you could generate your number and then use somthing like

Left(ID,7)

to get the first 7 digets only before entering it into the database.

 

[runsh]

Thanks for response I fiqured that out.