[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