Hello. Can anyone help with this problem, please?

I am building a library database and I created the table «tbl_keywords».
This table has only one field named «Keywords» and I inserted some records on
this table such as «Fictional», «Romance» and «Technical», for example.

I inserted three combo boxes in the book form «frm_book» to allow the user
to choose the keywords associated to each book. The user can choose up to
three keywords of the table «tbl_keywords» for each book (one on each combo
box). Each keyword chosen is saved on the books record, as «kw1», «kw2» and
«kw3».

Everything is working fine, until this: I want to create a query that allows
the user to see all the books of one certain type, I mean, keyword. Imagine
that you need to see all the «Romance» books, for example. The problem is
that the query must search the keyword «Romance» in the three fields «kw1»,
«kw2» and «kw3» of the table «tbl_books», because the user could have chosen
«Romance» in one of the three combo boxes.

I hope I made myself clear, but ask me if you have any question, please.

Thanks in advance.

Best regards,

Acores