Clients have many Files
Each file has one Employee assigned.
Forms are Clients with a subform for Files.
How would I best place a filter for filtering records based on combo box of all Employees/named employees and if based on a query how would I design that.
I already have an employeess table. and a files subform as set out above