>>I am having a problem in the direction I want to head. I was hoping to use a DROPDOWN List for eye color. However, I am seeing data in the main data table where a person has one eye that is GREEN and a 2nd eye that Is BLUE, or vice versa, or lots of other variations.
>>
>>How on earth do you handle these multiple eye colors? Do you have to stick with a TEXTBOX only where the usr types in anything, or is it conceivable that you could possibly imagine and enter into a PICKLIST table all the variations on eye colors?
>
>:)) Make 2 fields - Left Eye color and Right Eye Color
>
>Just kidding.
>
>I guess the number of combinations for different eyes colors is not that big. Or you can have an entry in drop down - 'non standard' and if selected, let the user type.

Actually that's exactly the way it needs to be handled -- two data fields. See my reply to Cecil for a UI suggestion.