title: multiple criteria search
body: <p>I have multiple tables with Customer data (ex Customer Name, Customer Contact Name, Customer Service Item etc).  </p>
  
  <p>I need to enable search on these multiple columns across tables.  Then I have to use the search result to pull Customer information (I need Customer ID, or Customer Name).</p>
  
  <p>What is the best way to do this?</p>
  
  <p>Possible Solutions:</p>
  
  <ol>
  <li>Offer multiple filters (different search boxes), and then handle each result separately.  (The client does not prefer this, and wants it in a single box.)</li>
  <li>Create a temp table (CustomerID, Search Field Values).  </li>
  <li>Create index !?</li>
  <li>User inner join, and put logic into handling the search result!!!!</li>
  </ol>
  
  <p>Thanks.</p>