[AccessD] Paradigm for Keywords in a database

Let us assume two tables as Michael said, such that table A has Title "ABCDE" and the keywords table has A, B, C, D and E as associated (child) rows. In this scenario, given criterion "A or C" then your query becomes"

SELECT Distinct * From ChildTable WHERE Criterion IN('A', 'C'). (Not that IN() is by any means the optimal way to go, but it suffices in this case to demonstrate the How.

 
Arthur 



----- Original Message ----
From: Michael R Mattys <mmattys at rochester.rr.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Monday, February 12, 2007 4:08:34 PM
Subject: Re: [AccessD] Paradigm for Keywords in a database


What day is it? Oh, Monday.
Thought it was Friday Humor for a minute. :)

Eoin,

How are the keywords stored?

Are the comma seperated values in their own column?

Could you use instr() for the criteria in the query grid?

Would it not be better to associate each keyword with
a number in a keywords-table and then look it up?

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Eoin C. Bairéad" <ebairead at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, February 12, 2007 3:49 PM
Subject: [AccessD] Paradigm for Keywords in a database


Hi

I have a database where each record has a number of Keywords assocciated
with it. I can't for the life of me see how to construct either  the table
or a query to find, say, all records where the keywords "Access" Developers"
and "brilliant" can be found.

Any ideas ????

Eoin

-- 
-- 
Eoin C. Bairéad
Dublin, Ireland
Áth Cliath, Éire
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com