I have a small client database where id like to have a form with form search fields below that brings a list of search results.
- Search Name (Searches first name, last name or part of name returning ph, email , comapny name results)
- Search Keyword ( Any part of a name or phone number that brings up any related results)
- Reverse Phone Lookup (Can search by part of phone number or full number returning results of first name, last name, company, email.)
I have yet to setup any queries yet...Just have main contacts table with lookup to company name. thanks