Hi,
I am setting up a fine-art greeting card site. It's easy to put any card in any one category. But many of my cards are quite suitable for several categories.
Given categories: landscape, marine, sympathy, etc.
A card may be a marine landscape and be unsuitable for a sympathy message. Another card may be a landscape and suitable for sympathy use. And so on.
Duplicating the cards would not be a good idea. I have at least 15 categories, and all of my 225 or so cards are suitable for at least 3 and usually for 5 or 6 categories. I don't even want to think about the permutations and combinations of that!
Any ideas on how I can set this up?
(In database terms, I need a many-to-many relationship connecting products and categories.)
Rob



