Key words - Microsoft Community

i grant writer building dataset of grant opportunities, working in access first time. want able mark each grant identified key words can query and create reports show opportunities assigned key words. have made couple of attempts , wondered if there better way trying. did below.

1. created table key words , made key word field , linked table.
   1. what liked: choose multiple key words
   2. what concerned me: how tables storing multiples each record , when run reports lookup tables, shows numbers, not actual key words
2. make each key word it's own yes/no field
   1. what liked: it's easy do
   2. what concerned me: lot of fields , i'm concerned it's going make building queries difficult.

   
   
   able select multiple key words while building query (for example, wants grant stem related , includes mentoring). however, reports going change on regular basis. advise appreciated!

"to choose from" suggests combo box on subform while "record source" suggests form or report data source. if mean combo box, row source be:

select [keyword id], [key word] tblkeywords order [key word];

Office / Access / Other/unknown / Office 2016