is there a way to do a find using drop down menus

[solarpunk]

Hello,

I was wondering if there is a way to do find using drop down menu. where a person selected what they want to see and than click on button that will run the script?. i am new to FM. wondering if it si possible. you can view a picture of what i am trying to do at this url: http://www.asmt.com/dblayout.gif where the yellow box is locate, it is what i am trying to do. if above is not possible how can i do using check boxes like this layout http://www.asmt.com/layout.gif

[Lee Smith]

Here is a very simple file that show how to do this.

It is called Doit.

HTH

Lee

DoIt.FP5.zip

[solarpunk]

Lee,

Thanks for your help. i am new to filemaker pro. i will study the file you attach. the part that i am wondering how can i set up so that i can have 4 drop downs menu and figure a way what value has being selected from those drop menus. I have attach file so that you see, take a look at layout data entry and the box area where it say Funding Report by:

Thanks,

Victor

[solarpunk]

forgot to add the attachment.

multi-find.zip

[Lee Smith]

Hi solarpunk,

First of all, you don't need to send back the file unless you have added something to it.

Second, the four list are attached to separate fields, right?

The you could make a calculation field that would equal all four combined (called Concatenated in FileMaker terms)

An example would be

Your calculation field (result = text) =

Field1 & Field2 & Field3 & Field4

HTH

Lee

[solarpunk]

Lee,

The reason i send that file was to show you how i am doing the drop down menu. i am newbie when it come to filemaker pro. I am not very familiar with calculation, i was wondering if you can take a look it at the file and give me some example how to do it. I am going to study the code more today. i will let you know how it goes.

thanks

victor

[danjacoby]

Am I crazy, or is there a simple answer?

"Drop down menus" are called Pop-up menus, or Pop-up lists.

Create a layout that has all the fields folks might want to search on, and set the fields up to be pop-up menus (you'll have to create value lists for each of them -- I suggest having the value list equal all the contents of the field; that way, the pop-up menu will give them a choice of all the values that actually exist).

Now create a script that goes to this layout, enters Find mode, then pauses. After the pause, it performs the Find (make sure to uncheck the "Restore" button) and returns to the original layout.

Simple.

[Ugo DI LUCA]

Hi all,

I'll make both Lee and Danjacoby happy today

Lee suggested :

Your calculation field (result = text) =

Field1 & Field2 & Field3 & Field4

Call this calc "Main_Concanate"

Danjacoby said :

create a layout that has all the fields folks might want to search on, and set the fields up to be pop-up menus (you'll have to create value lists for each of them -- I suggest having the value list equal all the contents of the field; that way, the pop-up menu will give them a choice of all the values that actually exist).

Then Ugo says

Create 4 globals g_g_field1, g_field2, g_field3 and g_field4, place them on Dan's Layout and re-use Lee's concanate calc with the global fields :

Global Concanate = g_Field 1 & "-"& g_Field 2 & "-" & g_Field 3 &"-"& g_Field 4

Set a relationship Global Concanate::Main Concanate.

Put a button at end of Dan's Layout with a 2 lines script attached to it.

Go to Related record

Go to Layout (where you want them to see the results).

[solarpunk]

I got this to work. Thanks all for all your help. i really appreciate it.