>Vlad,
>
>Why not use a single table that contains:
>
> Word
> Link
>
>Where "Link" contains a unique identifier for the record that contains this specific word. You could then use a SELECT such as this:
>
>sele * from musictbl, dict where musictbl.unique_id == dict.linkid and (dict.word = "HOLY" or dict.word = "NIGHT")
>
>Is there some advantage to your approach that I'm not seeing?
>
>Pete
What you say
is the basic approach, as I understand it. The other table, "Words", would be optional: A reference (listing) of all words available.
Unless you prefer to work with surrogate keys (as I do); in this case, the listing of words becomes necessary, as a lookup table to the surrogate key of each word.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)