I have a database in FM Pro 11 with two tables. The first one (named concordances) holds sentence fragments, in which each word is in a separate field. I use it to search for occurrences of particular words in field word06, for instance the word 'part':
etc. up to record 771.
The second table (named corpus) has all the word frequencies in the whole database:
etc. up to record 101576,
What I'd like to do is to calculate the joint frequencies of words in fields word01 through word06, and then match these with the frequencies already in table corpus. This would like something like this:
frequency in found set: 36
frequency in corpus: 28373
frequency in found set: 22
frequency in corpus: 24761
Thank you ahead for any pointers!