I have two tables. One contains Titles of Music. The other one contains
Scores. The relationship is based as follow:
Titles!TitlesID is linked with Scores!TitlesID (Many scores can exist for
the same title).
In the Scores table, there is also a field call "VisibleForWeb"
My problem is this one. I want to show only the titles that are visible for
the web, and I don't want duplicate names (e.g.: I have 30 Agnus Dei
different scores, but only 20 are allowed to be visible on the Web).
Hence, my SQL should read something like: Select Titles in "Titles" ...