keyword filtering on a list

[DaveC426913]

I'm creating a very simple List for use as a company Knowledge Base / FAQ. It has just three columns: Question, Answer, Keywords.

I don't understand how the filter works.

When the user selects the Filter button, it exposes dropdown boxes for 3 out of 4 columns (doc type, Question, Keywords).

The Keywords dropdown contains the whole list of keywords, the user doesn't get to pick and choose:

My data:

Question     Answer     Keywords

Qu1          Ans1       sales, IT
Qu2          Ans2       IT, design
Qu3          Ans3       sales, design

The user's choices in the keywords filter dropdown are:

- 'sales, IT'
- 'IT, design'
- 'sales, design'

- and that's it!


How do I arrange it so the user can filter for 'sales'? I don't want to create a new view for every possible combo of keyword!

Thanks.

D.