Pass more than one parameter from a single drop down selection

[ktolopka]

I am looking to retrieve some information from a database and have 3 dropdown/input fields on my page. I would like to be able to pass in a group of "Status" items to the query below. For example, I want the user to be able to select individual statuses for Open (OPN), Closed (CLO), Fixed By (FXB) but also want options for All Open types which include both OPN and FXB. I want the user to select a single item from the status selection that passes in both values into the query. I would appreciate any help

Thanks

Ke

SELECT * FROM CMSBNK, CMSCUST WHERE (UCASE(CMSBNK.RPTID) = UCASE( '::RPBKID::')) and (CMSBNK.CMS# = CMSCUST.CMS#) AND ((ENHSTS) Like '::Status::') ORDER BY ::ORDER::, CMSBNK.CMS