Adding keyword to use for a search

[Guest]

Hi

I need to create a document database.

When entering a new project you should be able to connect some keywords
(maybe 5) to every document, choosing from a list of keywords. You should
also be able to add keywords to the keyword list.

The keywords will of course be used to search for documents. It should be
possible to search on more than one keyword at the time, (both "or" and
"and").

Very grateful for any ideas on how to construct this.

All best

 

[Guest]

Use a autonumber key-field with you document - like --
Key - autonumber
Title - text
Summary - text
Document - memo

Next build a key word table linked with the document table - one-to-many on
the document key-field.
DocNum - number
Key Word - text

 

[Guest]

Thank you very much for the quick help. Made my day!

 

[Guest]

I missed the second part of your question - Searching on more than one key
word at a time. Use the following for criteria if you want to find one OR
the other keywords --
Like [Enter first keyword] &"*"
Then on the next criteria row use --
Like [Enter 2nd keyword] &"*"

If you want it to contain both of the keywords use --
Like [Enter first keyword] &"*" AND Like [Enter 2nd keyword] &"*"