Can you show your relationship too please..
At 1st glance you seem to be doing this the hard way, but let's see...
I absolutely agree I am doing it the hard way. As of now I don't have any relationships set up. It is raw data in the form of each primary word (table name and field name) and its synonyms (each as an individual record in that table).
Any help is greatly appreciated.
I agree with Phil.. You should be using this
here are two ways to set this up:
1) Use a join table:
Words::__pkWordID = Synonyms::_fkWordID1
Words2::__pkWordID = Synonyms::_fkWordID2
Instead of calling it Words... call it MasterWordList or something like that.. So your not confused.. All your Primary words will go in this table.
Then you will need 2 more tables for the many to many relationship..
One Table we will call Synonyms and one we will call SecondaryWordList.
Now you need to connect them in a relationship as noted above.
Put all your words you want to relate to the "MasterWordList" into the SecodaryWordList Table.
You will then use the Synonyms Table to relate the two tables and pull everything together..
Hope this helps..
I don't know whether the file at the following link will do what you require - it was made for something similar but using only one table of words and definitions.