Use a script trigger. Layout Mode --> Format menu --> Set Script Triggers.
Can anyone please give an idea of how the script would look like...Im a beginner and struggling a bit
Well, you first want to create a Value List ( File > Manage > Value Lists ) with these choices in them. The next question is do you want to prompt them in the browse mode or find mode. The traditional way is to go to find mode, have them selection from the value list choices in the dorp down, and then have a button or script step that does a Perform Find script step. You can also do this in browse mode if you create a global input field. The script would then set a variable equal to the global field. Then you Enter Find mode. Then you set the field you will be searching on to the variable. Then you do a Perform Find script step. If this doesn't make sense, I can email you a sample file that does this for you to see. Just let me know.