Multiple keyword search

[Guest]

Hey guys

I have created my image database and would like to be able to add a multiple
number of keywords to each image in which i can do a search on for example.
Image One - Landscape shot - Keywords= Grass / Trees / Water
Image Two - John Smith - Keywords = John / Smith / Water / Portrait
Image Three - Ponds Keywords = Chain of ponds / Water / Banks

I would like to be able to search for a number of keywords

Please give advice?

By the way i have to say this site has been most helpful.

 

[storrboy]

I assume you're after whole word matching?
I would allow typing a list of keywords into a single text box on a
form using a space to separate them. Create a function that splits the
entered list into an array of values to search on. Another function
(or maybe the same one) would loop through the elements of the array
and build a sql string using them as criteria The WHERE portion would
end up looking something like ...WHERE(tbl.Keywords LIKE "*/keyword1/
*" OR tbl.Keywords LIKE "*/keyword2/*".... The sql returned by the
function could be used to open a query, report or applied to a form
recordsource.

 

[punjab_tom]

Full Text Search; which is _FREE_ with SQL Server; this works quite
well for these types of searches.

MDB is stuck in the 90s