Posted on: 3/9/2015 2:50:19 AM | Views : 490

Greetings gurus.
Please take a look at this link:
Categories
On that link, please notice several categories with links.
Such categories are, just to name a few, Current[53], Current Bid [4], Current RFP[2], etc, etc
Current[53] means Status is Open and there are 53 of those.
If you click on any of the links, all 53 records are displayed. You click on Current Bid, all 4 records are displayed.
We would like to do something like those but slightly different.
For instance, rather than have those laid out as they are, we would like put those in dropdownlist.
This way, once a user clicks on any of those, similar results are displayed.
To get the relationship, we have status table with following fields:
Status tableStatusID integerstatus Nvarchar(50) Sample ...

Go to the complete details ...