Finding multiple range

[lazyyy]

Hi all,

I have a set or data serial

A1 to A9000

now, how do you find A1 and A100

I can do it easily in google like typing

"+A1 +A400" or maybe "A1 and A100"

I need to do the same with Filemaker?how?

Plus how do to find "A1 to A100" and "A200 to A300" and "A8000 to A9000"

How do you do it?

Thanks for all the input.

[faaslave]

now, how do you find A1 and A100

I can do it easily in google like typing

"+A1 +A400" or maybe "A1 and A100"

I need to do the same with Filemaker?how?

If you want to make two find requests in the same field. Eneter find mode, type in A1, then go to the request menu up top, and select make a new request. Now you type in A100 in the field, then perform the find.

Plus how do to find "A1 to A100" and "A200 to A300" and "A8000 to A9000"

How do you do it?

Thanks for all the input.

A200...A300

You should be able to go to Filemaker help, type find in the search field, and it will give you all the possibilities.

Remeber that when you go to the request menu and make a new find request, you will notice you have two records. You can multiple find requests all at once this way. Also, you can type into more than one field on each request.

Find

Name Don

State CA

This will find all the don's that are also in CA.

Name Steve

new request

Name Ron

State UT

this will find all Steve's, and All Ron's that are in Utah.

Dave

[lazyyy]

Great thanks

now how do I put "add new request" in a script?

Thanks a bunch

[Lee Smith]

Use the script step "New Record/Request"

i.e. something like this.

Enter Find Mode

Set Field [Table1::FirstName; Don]

Set Field [Table1::State; CA]

New Record/Request

Set Field [Table1::FirstName; Steve]

Set Field [Table1::State; UT]

HTH

Lee

Edited September 16, 2006 by Guest