multi-key Problem....

[George TOUBALIS]

hi there.!

I have 3 tables

1) Sounds table

2) sounds keys

3) lineitem

Every new record in "sounds table" is actually a new sound

with children a few key-words like "Organ", Violin" "Horn"

These Key-words are records in sounds keys

When I make a new sound (in sounds table) I feel a portal with some keywords.

this portal is from line items table

My line item table has 2 fields Sound_ID and Word_Key_ID

I want to fill 5-10 temporary fields with keyWords and show the found sounds in a portal

Of course I don't want a sound appears more than ones.

For examble

If I have feel 3 fields with "Flute", "Melodic"& "Country"

I want (in a portal) sounds with children: "Flute", "Melodic" &"Country"

not a sound with children:"Flute", "Melodic"& "Bass" just becouse it has "Flute"& "Melodic" common

if I type "Flute"& "Melodic" it can appeare but when i type also a "Country" I Don't want to see it in the portal.

How can I relate the sound_table with Lineitem table?

George