Ok,

I'm developing a searching process using 'metaphone algorithm' in my library program.

I have 2 table: Tcode and TBooks. Tcode is a table to store words and its transformation code, so it has 2 fields, cword and ccode. Tbook is a table to store information about a book. It has some fields including cBookID, cTitle, cAuthorId.

Here is the search process and the problem is on the 2nd step:

1.I filter Tcode table using SET FILTER, based on the keyword, and display
it in a grid (GrdCode); it works nicely.

2.I need to filter Tbooks based on the result of 1st step (word(s) that is
displayed on GridCode), then display it on a grid (GrdBook) as the final
result. This step runs automatically after the 1st step.

What should I do?