>>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?
>
>Out of curiosity, what kind of application is it where eye color needs to be tracked? Something for optometrists or opticians, I hope.
>
>Re your question, if left and right eyes can be different colors, you need to track them separately. Put them in a group box and make the opposite eye default to the same color as the first one chosen so it's no extra work for the user.
Actually, the solution in GIMP (and probably few other open source apps) comes to mind - when resizing, by default the other dimension is recalculated, i.e. you change one and the other one changes automatically. But if you want to step away from the default, there's a line connecting the textboxes, and a little icon of a chain link on it. Click the icon and it's now an icon of a broken chain - and it stops recalculating.
IOW, the two textboxes are linked by default, can be unlinked at will.