Dropdown list - guidance

[jeffw]

Hi everyone. I am looking for some ideas on how to solve 2 problems with a dropdown list. I have a layout with the customer records on it. I want to have a dropdown list that shows status.

So the dropdown list will show active, inactive or all customers.

My questions are:

1) What field do I use on the dropdown? I cant use the status field can I? I dont want it to update the records just to filter them.

2) How to I handle the All filter? There isn't a status for All in the table. I was thinking about an IF statement in the script to show all if dropdown = All.

Any help is appreciated. Thank you

Jeff

[bcooney]

Are you in a list view of customers? What kind of field are you using for Status?

Sounds to me that you just need to use a Find in order to see customers of different status and Find All.

[jeffw]

It is a view. The status field is a text field. I am going to try the drop down over top the status field using a value list with a find script. It should work. Thanks

[bcooney]

"It is a view" - what does THAT mean? A List view, form view, table view.

You don't need a drop down of any sort. Just hard-code find buttons.