Re: Thesaurus

Sometimes writing a question down helps solving the problem. Well not really
solved it, but realised a completely different solution would work just as
well. So no more cascading relationships, but simply transfer data from a
to b then deleting record a. In the end exporting the remaining records.

Ursus

"Ursus" <ursus.kirk@xxxxxxxxx> schreef in bericht
news:b060$491ee778$5ed017f3$21698@xxxxxxxxxxxxxxxxxxxxxxxxxxx
FMP9adv XP

A while ago I had some questions about setting up a thesaurus. I need some
fresh input now.

I create a table with two fields
ID
Word

And a second table
ID1
ID2

So when see a word in table1 that has a corresponding word I add a record
to table2 and just enter (scripted) the two IDs.

But now I have become stuck with the exporting part. The words are going
to be used in an external database. This uses the format that all the
words on one sentence are synonyms. Now I need to export all the words
with synonyms attached only once. In other words, when a word has been
used it shouldn't be used again for exporting

Like ABCD = EFGH. I start with ABCD, let a script loop through the records
and skip the EFGH.

Second problem. ABCD might be linked to EFGH and linked to IJKL But on the
other hand
ABCD might be linked to EFGH, and EFGH linked to IJKL. Subtle difference
but how to cope with that?

Well any input appreciated.

--
Keep well / Hou je goed

Ursus



.

Relevant Pages