Jump to content

Archived

This topic is now archived and is closed to further replies.

Robv56

Search options

Recommended Posts

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.