KeyWord search

[ionic-fire via AccessMonster.com]

I am in the middle of programming a search form, and one function I wish it
to have is the ability to search by keywords. Currently, I have a one-to-many
relationship set up between my main table and the table holding the keyword(s)
. They are related by the field lngRecID. On my data entry form, I have a
continuous subform with combo box controls on it to display and to facilitate
keyword entry.

My question is a somewhat dubious one. In an earlier thread, I saw a solution
by Allen Browne whereby the user had stored all the keywords in one field. He
then splits them into an array and generates an SQL statement dynamically.
Which way is the proper way to store the keywords? I was under the impression
that using a related table was perfect for this application.

If the related table is the proper way to store keywords, how would I display
searched-for results? I would need a query that contains the main table and
the related table, correct?

 

[Arvin Meyer [MVP]]

You are correct, a related table with 1 record for each keyword is the only
correct way to store a list like this. Run a query with the 2 tables joined.

Allen Browne's example was for the multi-value field in Access 2007 which is
only useful with SharePoint, since there is no way to relate tables in
SharePoint.