General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
You can use Parameterized SQL Views, and each time the key changes, just requery() the views and refresh the form or individual controls. Or you can redo your select statement with a 'where' clause keyed to the primary key in your parent table.
Alan
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only