>Hi Tore.
>
>Sorry for the delay in answering.
>
>The problem is that if I do not use $ and filter on Department+Section+Unit, I will end up with a huge filter string. I can't build up the filter for department, section, and unit individually.
>
>If i have the three individual indexes and then do the filter as it was originally (Department+Section+Unit $ cDepSecUnit), it still won't be good ?
>
>
>Thanks
You can easily use a variable WHERE clause, with macro substitution, i.e., the "&" sign.
For example:
lcDepartment = ThisForm.TxtDepartment.Value
if not empty(lcWhereClause)
lcWhereClause = "Department = " + lcDepartment
endif
...
select
...
where &lcWhereClause
...
Combining two or more expressions with AND is a little more tricky, but perhaps this gives you the general idea.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)