OK you guys, I have a question on this one.
I am using CB 1.2 and have set up a field called Favourite Music.
Lets say that I have added the following into the Favourite Music Tab
Rolling Stones, The Jam, Coldplay
OK, now I know that I can set this field as searchable, and then create a list that allows users to search on this field.
But here is the thing, I want to set up an automated list that will search the Favourite Music field for matches with other users.
In other words, I want to have a link called "find users with similar tastes in music" that when clicked on by a logged on user, will automatically generate a list of other users that also have any or all of Rolling Stones, The Jam or Coldplay. I also want these users listed in order of highest amount of matches first.
Any SQL guru's out there that can help?
Kind regards
Gary