|
| |
|
|
bnbalestri
Posts: 48
Joined: 3/7/2002
From: Bloomington MN USA
Status: offline
 |
Searching multiple fields in multiple tables - 5/24/2002 11:45:25
I don't know if this is possible.
I'd like to build a search function that will search multiple fields in multiple tables with only one search box. The two tables are Contacts and Notes.
So for example, I'd like a user to be able to type "Jones" in the search box and have it return:
(From the contacts table)
__1) Jones, Bob.....Wells Fargo
__2) Smith, Jane....Jones Landscapers
(From the Notes table)
__3) Directions to Ted's - ...turn left on Jones Avenue...
I can't join the two tables (currently) to create a view because they don't have any common fields.
Any ideas?
Brian www.allpointsfeedback.com
"...because employee reviews suck."
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
