I want to create a user control, but could use some advise for the best approach.
Tables: For example: PRODUCTS TABLE with following fields:
ID, Name, SupplierID (FK), CategoryID (FK) Comments, Price, ...
Search box, like google, autosuggest dropdown list.
Search should go trough all text fields, including Foreign tables
The searchbox should display the product name and be able to return the ID from the product.
I could use some advise on what controls to use and how to get the best user experience.