multiple field search

[gaift]

i was working on making a database that would hold references to whitepapers for a company, since Windows os only lets you try and find files through one keyword or phrase, i was told to make a database taht would let you search possible words in a file with around 5 keywords. Each employee will be required to give 5 keywords on top of their whitepapers. What i intended to do is to make 5 fields that would hold the keywords. I was wondering however if i could search in any of the 5 fields that it would return all the records that have that value in any of their fields. i.e. the first keyword field may have the keyword "target" however many of the records that have the value target may be stored in the second
third, etc. field.

thank you

 

[JeanW]

Make a ¶ list of your terget names.
Search on this field or make a relationship between the 5 fields andthis list.