My fake online cd/vinyl store. Trying to setup a good search+results+details system. I am **** at explaing and it's easier with pictures so i made these:

The tables in my database.



What i am tryng to do.



I have done some very basic search and results before but not with more than one table like this, i am a little confused, i can layout/output the stuff with CF fine it's selecting it and getting the search working well that's the prob.

(using .cfm pages)

Any suggestions would be lovely