Oct 28 2006, 02:43 AM
I have a table with a list of songs and a table with a list of keywords. I would like to know how I can associate each song with 1 or more keywords and create a query so that the end user can input a keyword or phrase (eg. 'love song' or 'ballad') and then see a list of all songs that meet the criteria. Thanks.
Oct 28 2006, 03:01 AM
You might want to take a look at this link
Oct 28 2006, 03:10 AM
Thanks Lou. I've downloaded the sample DB. At first glance it looks a bit complicated and I'm not sure how I adapt it to fit my own needs.
Oct 28 2006, 05:21 AM
It is not all that hard. So if you have any more questions just ask.
Have a great day
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here