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?