I have 2 tables A & B. In table A I have a description field which contains the basic description of a record and its data type is nvarchar(500).
In Table B, I have a requirement field with nvarchar(500) datatype.
Now I want that as soon as I type into Requirement textbox for table B, and tab away, a popup/form must show with the mathing records which are matched from description field of Table A.
Both Descrption and Requirement fields have values related to place, age range, and other stuff.
Can any body please tell me how it can show that form/popup with matching records. Is there any other approach?
Please give me sample code.