Seach with two drop down list

[ibizamale]

Hiya All,

Heres my problem.

I have a list view for Orders:

I have 9 collums.

i would like two drop down boxes at the top.

and when changed the i would like the following to happen:

1st box called EN_FILTER_STRING (global text)

2nd box called EN_FILTER_STRING_Status (global text)

if a value is selected from the first box then only vaules with that data fronm the "Stage" collum is shown

if a value is selected from the second box then only vaules with that data fronm the "Status" collum is shown

Example

1st box ADMIN is selected then the list only shows the data with ADMIN in the Stage collum

if the 2nd box is changed to OPEN then only data with the Stage as ADMIN and the Status as OPEN will show.

Just one more small thing i dont want to show and items where the status is set to completed unless i tick a box

Thanks for your help in advance

Regards

[bcooney]

This can be easily done with script triggers and a find script. Every time one of the globals is changed (I'd do OnObjectModify), you can trigger the find.