Sergey,

In my application the users query a table. The matching records from the table queried and other tables that are linked to this table are displayed to the user.

The other tables are connected to the table queried using Set Relation command.

I was also using 'Set Filter' commands to filter certain records.

But it was notices that using 'Set Filter' made the searches very slow. So now I am recoding so that I use Select SQL statements to extract data to variuos cursors, and the data is displayed to the users off of these cursors. It has made the searches quicker.

But now my problem is that since the cursors are not related, when I move to another record in the 'queried table' the pointers in the other tables do not move as well. I was wondering whether, I could accomplish this with the Select SQl.

Ria.