I would like to be able to have a drop-menu that when you select one of the values from a list it will automatically run a script as soon as the selection is made without having to perform any other additional action such as clicking on a button or choosing a script from the script menu.
For example, I have a database of furniture which includes categories of chairs, tables, beds, mirrors, sofa's, etc. I want to set up a field as a drop-menu of the above listed furniture categories and perform a find on the selection. So if I pull down mirrors in the drop-menu I want the database to find and show just those items that are mirrors. And I want the find to happen the instant I select the mirrors value from the drop-menu. I don't want to perform any additional actions like clicking on a script or on a button, etc.
Is this possible?
The reason I would like to be able to do this is to save a significant amount of time for the user. The database I currently have set up uses several of these search fields and a user will typically use them several hundred to a thousand times a day. If I can cut-out a step it would save a lot of time and create a much smoother workflow. I've seen this type of drop-menu used on website's, but I have not been able to figure out how to make it work within filemaker.
Thanks ahead of time.