>>>>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
OK I get it. Since this was an already built application, I would have to change some things to eliminate the I.D. as a field that the user sees. Thanks for the input.
Bill
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!