Display by attributes - How do I do it?

[LouAllen]

You could acheive this with categories and subcategories. Not an ideal solution but it might be worth considering until you find a better solution.

ie. you could create another category called "Sacramento" and link all the products from your current categories that fit that criteria. This category could then have subcategories for "Artist", then the Artist category could contain subcategories for "Framed", "Unframed" etc.

Yeah, that's what I was thinking I'd have to do, since I'm really not a php/mysql guru. Is there a way of deciding where the categories show up in the sidebar lists and the header navbar, so these secondary categories aren't showing up EVERYWHERE with the others?

[gjh42]

Yes, I worked out some code to do this a few months ago. It is in the Parent Categories Separated In 3 sideboxes thread.
It could be adapted for other locations I'm sure.