I would like to take a text box, which is bound to a table, when the value is entered, it automatically prompts another textbox, based on the entered value to produce a specific value for it. Ex.
I enter "Apples" in textbox 1
then based on Apples in textbox two it automatically makes "Red"...