General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only