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