>>>That is a neat idea but after I have built this table with integer numbers, how does a user know what number to next assign when they want to add another choice to the file through the program?
>>
>>I am not sure I understand your question
>>
>>
>>Arnon
>
>I am using an incrementing alphabet to build a table of existing values having only three characters for the value's i.d. After the table is built and the user is adding values to the table, how would they determine the next value in order for the i.d. if integers are used?
>
>Bill
just add 1 ?! :)
basically you can build a stored procedure which will auto increment the field
so the users will not have to deal with this at all

Arnon