I have 2 tables...the first is the Customer_Info Table and the primary Key is Quote_ID. The second table is the Quote_Requirements table which has a compound primary key (Quote_Id & DetailID). I am trying to write a function in VBScript that will increment the DetailID (i.e A, B, C etc.) part of the compound primary key so that the Quote_Id will be inserted as many times as the user creates a new detail for that Quote. Here's what I have right now. What is happening is when I test out the function it writes out a 'D' because of the first letter in CurrentID.

Function NewDetailID()
Dim MyNumber, MyChar
MyNumber = ASC("CurrentID")
MyChar = CHR(MyNumber + 1)
NewDetailID = MyChar

End Function
response.Write(NewDetailID)

I need some help in understanding what I am not doing correctly. Thank you.

ASC("CurrentID") will always return 67 because "CurrentID" is a string literal that starts with "C"

If I have read the code correctly;

NewDetailID = CHR(ASC(right(CurrentID,1)) +1)

will get you what you need in a single line of code.

Is there any reason in particular you're using character data instead of an integer for part of your key? Things would be much easier otherwise, and while a single-byte column is scalable, ints might take less CPU power.

I don't understand why Quote_ID isn't the foreign key in the relationship and why DetailID (assuming it's autogenerated and/or incremental) isn't the primary key by itself.

Other than that, what Hirst said.