I would agree that if one can filter a record set and subsequently filter it further, it would be logical to assume it can be done in one step - provided you know at the first step what the second filter ought to be. If your process is to filter food records then "green" may not be suitable as a second filter if the first filter (FoodType =) had returned meat, as much as if it had been "vegetable". If that is the case, then the primary set could be filtered to the final desired result by reconstructing the first filter, as in
WHERE FoodType = "vegetable" AND Color = "green"
once you have captured the second filter value. If that doesn't describe your process, then you should elaborate on what you've tried, what the process is, and what results you got from your prior attempts. I think we are missing some of the picture here.
- "doesn't work" is no help.Error #s/text do. State what's happening.
- Use code tags for code/sql; show where errors occur
Make all suggested changes in copies of your database or to its objects