Hi

I have an access database that i would like to search. Its for a search engine where the user will type in a search term and the program (in asp) will query the database.

I am struggling to construct the query as not all of the tables are related.

The tables are constructed as follows:

Product Pictures
ProductCode
HiResPath

Products
Productcode
Datasheetfilename

News
newsStory

Promo
promoStory

subcategories
subcategoryName

Is there a way to write a query that can search these required tables and fields?

Any help would be most appreciated.