Search options

[Robv56]

Hello:

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.