Hey
I am having a little trouble in working out the best way in which to query my database and hoped you guys could help me. What i am looking to do is to search a using a textbox, the problem is that there is not only one field or one table I want to search for. For instance I have a table of parts that contains the part number, part name, the associated project number, searching for these would be relatively straight forward, I also want to be able to search based on the project name (this is stored in a seperate table) I have thought about using a drop box to allow the user to specify which column they want to search in however this didnt work very well. Ideally i will be able to add more search functions onto this after
Some help on the best way to go about this would be greatly appreciated
Chris
...
Go to the complete details ...