Thread: Ref numbers
View Single Post
  #1 (permalink)  
Old January 16th, 2008, 06:22 AM
RubyRue RubyRue is offline
Registered User
Join Date: Oct 2007
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ref numbers


We are currently building a system where a user can submit a request and is given an automated ref number ie 1001 (we are using identity in sql to auto generate the ref number). If that request gets rejected a user can resubmit the request by entering their ref number which will bring up their previous request, amend it and submit it again however when they submit it it adds an a, b, c etc to the end of the request ie 1001a. We have created a separate table in the db to hold the re-submitted requests so as not to overwrite the previous requests and so it doesn't auto generate a new number when another row is added to the table and so we can hold the alphanumeric characters.

Is this the right way to go about it? Can anyone give us an idea on how to add the alphanumeric character to the end of the ref number?

Many thanks