Hello All:

How do I enter multiple values in a field when searching?

Sam

In article <1177564512.429323.149300 (AT) n15g2000prd (DOT) googlegroups.com>,
SamMc <FMP_account (AT) hotmail (DOT) com> wrote:

That depends on what you mean by "multiple values".

You can simply type multiple words in Text fields and FileMaker will
find records where that field contains ALL those words (or partial
words, eg. "egg" will find "egg" and "eggplant"). This is an "And
Find".

If you mean you want to find records where a field (of any type) might
contain "Fred" or "Barney", then you have to follow FileMaker's "Or
Find" process:

- Enter Find mode

- Type "Fred" into the field

- create a new Find Request from the Request menu
(the Records menu changes to Requests when in Find mode)

- a new blank will appear, type "Barney" into the field

- click on the Find button in the side tool-bar, or press
the Enter key on the numerical keypad, or choose Perform
Find from the Requests menu.

While still in Find mode you can move up and down through the Find
Requests using the side toolbar's flip-book (just like you normally do
with records in browse mode).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On Apr 25, 11:47 pm, Helpful Harry <helpful_ha... (AT) nom (DOT) de.plume.com>
wrote:
Thank you. It is a bit cumbersome, but will address my need.

Deguza

In article <1177709889.745212.81740 (AT) o40g2000prh (DOT) googlegroups.com>,
Kompu Kid <deguza (AT) hotmail (DOT) com> wrote:

Cumbersom?!? Possibly, but it is the standard FileMaker way of
performing an "Or" find since version 1. )

It often works better with a Layout displayed in List View - each Find
requerst can then be a narrow strip in the List, meaning users can
easily see what values they have already entered.

Another way would be to create your own "Find" function by having users
type the values into a Global field, toggle an "Or" / "And" radio
button and then click a button to run a script that separates out the
values and creates a Find Request for each one before performing the
actual Find.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Hello HH,

You've piqued my cuiosity here. How would you script multiple find requests.
I was toying with this the other day but couldn't seem to get what I was
looking for. What I tried was something like...

Enter find mode
set field 'name' to 'fred'
perform find (replace)
modify last find
set field to 'harry'
perform find (expand)

Should this work in your example?


"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote

In article <d1c51$463a39e8$d1a8fa82$24670 (AT) EDELTACOM (DOT) COM>,
"GSP@DavClaServ" <info (AT) davclaserv (DOT) com> wrote:

Scripting Finds (or pretty much anything else) is no different to
performing them manually, you still need to use the New Record /
Request command to create a second Find Request for an "Or" Find.

Instead of the silly "Modify Last Find" command, you should have a
script something like:

Enter Find Mode []
Set Field [Name, "Fred"]
New Record / Request
Set Field [Name, "Harry"]
Perform Find []

The New Record / Request command is in the Records section in the list
of the script commands.

This will find all records where the field Name contains either "Fred"
or "Harry".

Remember to turn off the "Restore" options for both the Enter Find Mode
and Perform Find commands, otherwise you'll get unexpected results.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote

It always amazes me at how something so elementary can escape me for so long
(and people all around me call me smart! If they only knew what really goes
on in my head.). Thanks Harry for my first 'duh' moment of the day.
Steve

In article <9f581$463b02c7$d1a8fa82$3752 (AT) EDELTACOM (DOT) COM>,
"GSP@DavClaServ" <info (AT) davclaserv (DOT) com> wrote:

The "Modify Last Find" command does have it's ocassional use, but not
for performing simple finds. The problem is that many people often skip
over the New Record / Request command without noticing the Request
part, and end up with the Modify as being the "only answer available".

It's not only with the Find procedure, and of course we have ALL done
something like that - the "duh" or "d'oh" moment when you realise you
missed the most obvious thing. The old "the printer's not working" -
"try pluggin it in". )


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)