I'm doing a sports scores application. I have a table of games that are on the schedule. Among other things, each record includes an away team name and a home team name.
Currently the games list page has a filter menu for each team column. The user selects the home team name from a drop down and the list filters by the home team name. Of course the same behavior exists for the away team column.
I would like to filter both columns from one drop down selection. In other words if a user selects the a team name from the filter drop down I'd like the results to include records with the selected team in either column.