Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement