Please see the attached DB and the form frm_KPI_Main
I've added a third combo box for the team leaders. What I want to be able to do is filter the cashier combo box based on their Team Leader. So TL 1 is selected then only the cashiers for that TL will appear on the cashier combo box.
However I also want the first option in the TL box as All to display all cashiers in the cashier combo box and for all to be the default selection (the TL filter will be for convenience only)