>>>>I want to set filter and then set filter again using the previous filter. Can I do that?
>>>
>>>Yes you can store filter expression and then use it again:
>>>set filter to id=123
>>>cFilter= filter()
>>>set filter to
>>>*** no filter now
>>>set filter to &cFilter.
>>>*** filter restored
>>---
>>Hi Edward
>>can you - set filter to id=123
>>and then in that filter,
>>can you set filter to name = 'mary'.
>>your records would look like this.
>>id name
>>123 mary
>>123 mary
>>123 mary
>>
>>inotherwords, can you set filter within a set filter?
>
>Simply concatenate the old filter and the new:

>SET FILTER TO id = 123
>lcold = FILTER()
>SET FILTER TO Name = 'Mary'
>lcnewfilter = FILTER() + ' AND ' + lcold
>SET FILTER TO &lcnewfilter

>hth,
---
thanks george :)