ACinKC (1/15/2013)
AndrewSQLDBA (1/11/2013)
It is like asking users to type in the state name where they list. Most will get the spelling correct. Some will not.And there's no way to limit what they can type in? Maybe change the text box to a combo to select a limited (validated) set of values? I'd rather have someone select 'KS' rather than typing in 'Kan'. Or 'OptA' rather than 'I think I have option A'...
Yes, this is the way to go: relatively simple change in the front-end. Create a lookup table in SQL, validate from the front-end what was entered, fetch the value from the lookup table.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience