Below is some ASP code that lets me search through patient data. I also can apply filters (date of service, department, etc.). The one that's giving me trouble is the one for "location".
There's 3 different sites, but within each site there's sub locations. Example, BIHP-IO and BMHP-IO would belong to BH (among others). You can see the details in the case statement.
SELECT CASE Location WHEN 'BIHP-OT' THEN 'BH' WHEN 'BIHP-H' THEN 'BH' WHEN 'EMHP-OF' THEN 'EC'...and so on.
How can I search by location and make (for example) BIHP-OT and BIHP-H come up when I select BH from the drop down? Right now it's sending the "BH" as the filter, and that's not a real location.
My complete code is attached.
<select id="location" name='location'>
If varSearchLoc <> "" then
Response.Write("<option value='" & varSearchLoc & "'>" & varSearchLoc & "</option>")