Hello
Here's what I'm trying to do. I'd like to add an "OR" to a few fields, so that when I do a search for "All Conditions" it returns relevent data.
I have a table called "Artists", and on this table are the fields "50's","60's", "70's"...etc. These are decades. I'd like to be able to make it so that the user can search for "Artists" that have "60's" OR "70's" with other info typed in (eg. Genre = Country). This would return all artists that have a decade of 60's, that are Country, and all the artists that have a decade of 70's, that are country...and all the artists that have both decades.
Basically, I'm looking to have the "Any Condition"apply to the decades....and the "All Conditions" apply to the rest.
Any help would be greatly appreciated.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=12323&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
