tables - keyword field

[Guest]

Just curious...I would like to have a field for keywords in my data table
that would be searched by a form-based query by the user. This field would
have multiple words. Do I need to separate them with a semicolon or
something?

The search will be open ended, ie) where tblkeyword = "*" & [dataentrybox] &
"*"

 

[Rick B]

No, you would not need to separate them with a semicolon based on your
search.

 

[Guest]

Do remember, though, if you are storing your keywords - rather than searching
a text field - you will do better to create a second table:

tblKeywords
[Table1].[PrimaryKeyField] [PK] [FK]
Keyword [PK]


Sharkbyte

No, you would not need to separate them with a semicolon based on your
search.

--
Rick B

Just curious...I would like to have a field for keywords in my data table
that would be searched by a form-based query by the user. This field
would
have multiple words. Do I need to separate them with a semicolon or
something?

The search will be open ended, ie) where tblkeyword = "*" & [dataentrybox]
&
"*"