Hi,

I have a set of three asp pages that work like this:
Page 1: User selects a parent category form a dropdown menu
Page 2: The info is passed to page two and the subcategories associated with the selected parent category are displayed as hyperlinks.
Page 3: Selecting a Subcategory from page 2 takes the user to page three where the user is required to enter a zipcode to search for contractors associated with the chosen subcategory. The results of the search are then displayed on the same page.

See this in action at: www.your-personalassistant.com/prototalk/index.asp

Download the zipped app at:
www.your-personalassistant.com/prototalk/prototalk.zip

<b>This is what I need help with:</b>

I need to modify page three to display its results based on a condition as described below.

The database table for the subcategories (ServicesChild) has a column called "DisplayOptions" in Text Format.

I want page three to display the details of the Contractors only if that subcategory's "DisplayOptions" field is set to "Yes"

I am open to any alternative options if mine doesnt make sense.

You help is appreciated.

Best regards,

Zain

Zain Magsi

Why not just filter out the:

DisplayOptions="No"

via the recordset on page 3?