>>Today's Quiz. I want to maximize the number of choices I can assign to a group of records so I choose to use the alphabet through a three character field. How do I programatically increment the next assigned alphabetic character (i.e. AAA, AAB, AAC. .. AAZ then ABA, ABB, etc.)
>>
>>do I do this with ascii character (chr()) assignments or is there an easier way?
>>
>you got several answers on how to increment a character field so I won't go into that
>but a point to think about
>if you are using VFP you may want to consider Integer fields
>they are 4 bytes long and give you 2147483648 positive option or twice from that including negative numbers
>the advantage this is that this is the fastest data type (for joins etc.)
>
>Arnon

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?

TIA,

Bill