If the user wants customer 7, and enters that ID, then instead of customer 7 they get all the customers with patterns A7 through L7 — an awful lot of false positives.
Printable View
If the user wants customer 7, and enters that ID, then instead of customer 7 they get all the customers with patterns A7 through L7 — an awful lot of false positives.
Oh I see what you mean!
So... should I make some radio buttons and then say "Search by..."
ID, name, etc...
That would rule out any false positives I guess :)
Right. Much better.
Checkboxes are a better option, though, in case they do want to search more columns at once.
Ah yes, clever thinking :D