it's will be verydifficult to search every field of every table for the input.
I suggest doing something like a drop down box with which fields to search and then a text box with what to search for. Then, you can setup your query based on the input.
As such all the data is dependent and related but still the database structure is isolated with respect to the features we are providing in the application.... like for example:
When purchase order is placed, table 1 is only updated
When equipment is tagged and bonded the table 2 is updated
When eqpt is issued to user table 3 is updated
When location is reqd or there are internal moves then only table 4 is updated.
Keeping all this in view the database was designed.
Now the most probable options the end user might search for username and want to know his corresponding location, what assets he has, what are the serial numbers of these assets and the hardware type i.e. desktop, monitor etc...
can u give me some pointers on how to go a about implementing the dropdown scheme and how to populate dropdown... Is is good to write cases like first search in all four tables and then depending on results find in rest 3, then rest 2 and finally one...
Regards
Abhishek
Unsolved 
