General information
Category:
Coding, syntax & commands
Title:
Filter a table based on some data
Dear all,
I've got problem at 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 their 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, and 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?
Love,
Gloria
Next
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