|
| |
|
|
jimminko
Posts: 58
Joined: 5/10/2003
From: Cambridge, UK
Status: offline
 |
many-to-many relationship search - 9/7/2003 6:04:38
I have tblWord containing WordID and Word
tblCategory containing CategoryId and Category
As a word (e.g Dog) can be in more than 1 category (Animal, Pet, Fourlegs)
I have a tblLink with WordID and CategoryID - a many-to-many relaiotnship
The 3 tables I joined in a query, and then using DRW I set up a combo to filter - one selects a category (e.g. animal), and those words in that category are listed.
So far, easy.
As you can guess, the question is, how do I set up mutiple combos (in DRW or hand-coded) that I can search for a word apearing in mutiple categories (i.e. for words that only found in both animal and pet)?
Ideally it would be open-ended (up to 5) as to how many categories one can choose.
Thanks for any help!
jim
|
|
 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 
