DRW FP2000 and Access2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 tables that contain different data based on addresses (they are from
different sources).

Can someone please tell me how I can fire a global search on all three
tables for keywords, i.e. "ACME Street" or "12" or "Google Drive" or "London"
to bring back results of any searches from the tables, which table the
keywords exist in and ones which dont exist in the talbes.

Thanks in advance.

skc
 
With the DBRW you are limited to 3 separate searches and results of each
- to access all 3 in 1 query you need to hand code the ASP code to loop thru the tables and appropriate fields

To get started here is a simple single table / field search sample
http://www.asp101.com/samples/db_search.asp
--




|I have 3 tables that contain different data based on addresses (they are from
| different sources).
|
| Can someone please tell me how I can fire a global search on all three
| tables for keywords, i.e. "ACME Street" or "12" or "Google Drive" or "London"
| to bring back results of any searches from the tables, which table the
| keywords exist in and ones which dont exist in the talbes.
|
| Thanks in advance.
|
| skc
 
Back
Top