Basic vs. Advanced Query
I have created a website that has four forms that are slight variations of one another. My website is a listing of a particular item that visitors wish to either sell or donate. So I have a form for group items, single items, donated items and then shoes. When visitors post items to my website, they would use the appropriate form (i.e., for donated items they would use the donations form) and the items would subsequently appear on the appropriate page. However, if for example a visitor searches for a red dress, I would like for them to get results from all four forms. Also, I would like them to be able to search by any one of the categories of a particular table (i.e., size, color, location) to get results. So I’m wondering, should I be creating an advanced query or four basic queries? Where do I begin? Thank you.
