|
| |
|
|
jimminko
Posts: 58
Joined: 5/10/2003
From: Cambridge, UK
Status: offline
 |
Connecting IDs within a table - 8/6/2005 18:22:01
This might be easier than I am making it... Anyway, I am using Access 2002 and ASP.
I have a table of words (tblWord) with each Word having an ID (WordID). If a word is a synonym, when someone looks up 'to run' I want to be able to link it to 'to hurry' so that they can see it is a synonym (don't worry now about the linguistics of that!). I could write the word 'to hurry' on the web page and then add in the link the WordID but that would be defeating the prupose of a database. It ought to be able to generate the list once I have related them.
So, is there a way of essentially linking one ID to another in the same table? I guess I should create a separate table and in some way link them in that; e.g.
tblWord
WordID
Word
tblLinks
WordID
Synonymclass
But there are many hundreds of word, and each is only related to two or three other words, so that I do not want to be making up hundreds of classes, and especially then having to add a word to one of them. Better just to relate the words in some way?
Thanks for any help!
_____________________________
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
