If you are sure of your indexes, I would suggest that rather than setting a filter you do SQL Selects to populate the grids on the screen based upon the security level. My experience with filters is that sometimes they are slow, especially if the filter set is small in relation to the total number of records.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
