One way of indexing string or text fields is to create a keyword index. The words that comprise the string are separated and stored as individual records in a related Many table. When the user needs to query for a particular word, or sequence of words, the Many table is searched for the keyword, and the related one record[s] can be found using the relation between the tables.

This technical note covers the third of three techniques for creating keyword indexes:

Part 1 coveres simple keyword indexing of one table. The technique also allowed you to create a list
of words that should not be indexed. (prepositions, for example.)

Part 2 discusses a technique that allows you to build synonym queries. This technique allows you to add synonyms to keywords so that querying for a particular word (such as folder) will also return
results with similar words (directory). You create your own entries.

This technical note implements a technique to use keywords to index across multiple tables.

Sample databases are included with each technical note.

Download Complete Tech Note & Example: Windows | Mac