Jump to content


Search options

  • Please log in to reply
No replies to this topic

#1 Robv56

  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 13 September 2005 - 03:30 PM

I am trying to create searching capabilities for my database. The options are to directly enter an ID# or to select a Brand, a Category or a combo of either.

I created a search page with 3 individual forms for each and it works fine, but I need to figure out how to allow the viewer to search any combination of BRAND (brand_id) and/or CATEGORY (category_id) from one form. Preferrably, I'd like to include the ID# (dcx_id) to the mix too, as explained in the first paragraph.

What SQL code do I enter into the Advanced Recordset screen to accomplish this? Not sure if it matters, but I'm using Tom Mucks Horizonal-Vertical Looper to tile the results.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users