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:
Is there a way to write a query that can search these required tables and fields?
Any help would be most appreciated.