Try not using the data type "auto-number" and but use "Number" instead in combination with the cf_max_id custom tag. Set the default value to 1000 or 10000. cf_max_id  will increment from the max id.

cf_max_id can be downloaded from: http://www.macromedia.com/cfusion/exchange/index.cfm

Stan

>Hi guys,
>
>When using Access when creating a field with auto-number is there a way
>to have it not start from 0?  I'd like to give users an 4 or 5 digit
>user id.
>
>Also, another thing I've been thinking of: is there a way to reuse old
>numbers once they get freed up?  Therefore instead of assigning someone
>with the next auto-number they would get the lowest freed up number in
>the database.  This question is just out of curiosity  but I won't start
>doing it yet (no ones in the database yet!).
>
>Thanks,
>
>Stuart (recovered from the chilli in my eye)
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to