>Hi Tore and Michel. I also wrote some routines a few years ago that does this. I guess we all have in order to solve this problem!
>
>My routines create an index in the source table which calls a function that updates a master words table and a link back table containing the links back to the source table. The use of an index on the source table allows the word master tables to automatically update as new records are added or removed from the source table or as the contents of the fields being indexed changes. This is usefull.
>
>It records word frequency and statistics as well. Most important is that it updates as the source table changes. The downside is that the words master file and link back tables plus their indexes were as big as the source table which effectively doubled the space requirements :( It is also an entirely VFP solution except for a small dll that a collegue wrote in assembler to parse all the words out of the source fields being indexed. This was for speed so that updates could be done fast in real time as records were added or changed.
>
>Michel, I can send you this code for you to see whether its useful to you/UT. (Don't laugh at it though - I know that it's not very professonal - <g>).
I see two things. The first one would be to release an article for the Universal Thread Magazine and to release the component in the Downloads. I will let the discussion evolve more so we can gather more feedback on the topic.