Can somebody help me with a very peculiar problem. Maybe its my lack of knowledge more than anything!

I have a SQL statement which populates a cursor with the results which is the recordsource for a grid. Everything works fine. Then and ONLY then I have 2 combos which I would like to filter the data within the cursor. I dont want to filter the cursor when creating it I want to do it later. The problem is in my SQL statement I try to find those records that are a particular design number like 'JKT400'. When I run the SQL I get a number of records which is correct. Then with the combo I try to find those records in JKT400 that have the type as Append:

set filter to cursorname.type='Append'.

The problem I have is when I run this I get all the design numbers again that are type Append. But the cursor has only those records that are JKT400. Why is this?

Its as if the filter has been applied to the original table that the cursor was populated from. I'm confused!! Can somebody help me!

Many Thanks in Advance