Thanks for your prompt response. I feel this suggestion can make my task easier. Just to make my question more clear, here is an example:
Lets say we have a table with column Fruit Name and Color. This table has 3 records [Apple,<blank>],[Orange,<blank>] and [Banana,Yellow].
Now as per normal filter what ever I select in name or color the corresponding will be selected. But my requirement is what ever u select in filter checklist, the application will show you Apple as well.
The solution looks good for the case when I am applying filter on column Fruit Name however I am not sure how to handle the condition where user selects the color as yellow. Surely in this case banana will be selected (being yellow) and I also want Apple to be there but not Orange (value of color for Apple and Orange is same <Blank>).
I mean to say something like, whatever column user may filter upon, the record with Fruit Name (a specific column) as "Apple" (a specific value) should never be filtered out. If possible just remove its values from all the filter check-list as after all this record will be selected irrespective of filter criteria.
Something like select all the records as per applied filters (all filters with "And" condition) + my particular record (an "Or"ed condition with the filter rules).
A short sample would be of great help here.