I don't think this is a cascading combobox issue.
I need to filter my query results based on two combo boxes - I want the combo boxes to work like an AND operator, rather than just filter the results on the last combobox. I also have a tickbox that should filter on one field, and I'd like that combined into the filter somehow.
Right now, I have a combobox that lists staff - selecting it shows the results filtered by staff. Great.
I also have a combobox that lists calls assigned to a team, selecting it shows all calls for that team. Perfect.
I have a tickbox to filter only open calls (unticking it lists all calls open or otherwise). This is based on a field in the table "isClosed".
What I want is to select either combobox and have the results updated based on the value in both boxes, and include the tickbox into the equation, allowing me to chose any combination of combobox and tick status, and get the results I want.
Can someone point me in the right direction please?
Thanks in advance!