Hello,

I was wondering if someone can help me. Basically, i am trying to do a find using a drop down menus. i have 4 separate drown down menu where the user will chose from. I am trying to figure out what what values have being selected from the 4 different menus.Than i want the user to click on Find button and they will go to layout call summary which will only show the records that containt the values selected from the drop down menus.

i have included fm file to give you idea. The one i am refering to is the one in the yellow box area in the fm file. I dont know where to start, i am newbie. i just now the basic of FM.

Thanks,

SolarPunk

multi-find.zip

Once values are filled in, link the search button to the following script:

Enter Find Mode []

Set Field [ Status, Status_List ]

Set Field [ Locations, Location_List ]

Set Field [ Year, Year_List ]

Set Field [ Class, Class_List ]

Perform Find []

Go to Layout [ Summary ]

BTW, your Year field is a text field but your Year_List field is a global number field. The Year field should probably be a number field.

Chuck

Chuck thanks for your help. Also CobaltSky help me to fine tune it to what i want to do it. if anyone is interested in the file let me know.

thanks,

SolarPunk