Combining find request

[Roseline]

Hi,

 

I have a find script problem. Some people already help me but I'm not sure to understand:

 

How can I perform, in 1 interface, 1 find button,

only 1 script that have many option?

 

I want to be able to search like this,

 

Name (all the personne who have this name)

AND

Firstname (all the personne who have a specific LastName)

AND

Language (all the personne who speak 1 or many of the language that I check:

French or English or Spanish)

AND

Hair ( same has the Language)

 

 

I have a find interface like this:

********************************

Firstname

Lastname

Age (checkbox) 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-91

Language (checkbox) (french, english, spanish, japeneese, chineese)

Hair color: blond, brown, black, red

Eye's color: green, gray, blue, brown, white

***********************************

and I have more others request.

 

thanks for your help,

 

Roseline

Quebec

Canada

***********************************************

 

 

************************

My original script

*********************

 

Set Error Capture (On)

Show All Records

Enter Find Mode ()

 

Set Field ("FIRSTNAME", "Globale_Prenom")

Set Field ("LASTNAME", "Globale_nom")

 

Set Field ("AGE", "Globale_age1")

NEW RECORD/REQUEST

Set Field ("AGE", "Globale_age2")

NEW RECORD/REQUEST

Set Field ("AGE", "Globale_age3")

NEW RECORD/REQUEST

Set Field ("AGE", "Globale_age4")

NEW RECORD/REQUEST

Set Field ("AGE", "Globale_age5")

NEW RECORD/REQUEST

Set Field ("AGE", "Globale_age6")

 

Set Field ("LANGUAGE", "LANGUAGE_FR")

NEW RECORD/REQUEST

Set Field ("LANGUAGE", "Globale_LANGUAGE_EN")

NEW RECORD/REQUEST

Set Field ("LANGUAGE", "Globale_LANGUAGE_AL")

NEW RECORD/REQUEST

Set Field ("LANGUAGE", "Globale_LANGUAGE_SP")

 

 

-------

 

here are some answer thaht I received but I don't know how to apply them:

 

-----------------------------------

request1 and request2 and request3 and .... must be defined into a unique

request

request1 or request2 or request3 or .... must be defined into more

request (request1 "new request" request2 "new request" ecc...)

 

If you have request1 and request2 and request3 or request4, you must

perform:

request1 and request2 and request3

"new request"

request1 and request2 and request4

"perform search"

 

Diego

 

-------------------------------------

Look what you just did:

Your first Find request asks, "Give me John Smith, age 30."

Your next Find requests asks, "also give me everyone age 40."

i.e., your NAME info is no longer applied in subsequent requests!

 

The answer is don't use NEW requests, use DUPLICATE requests.

Just be sure to clear out the appropriate fields, e.g., once you get to

your first "Language" request, clear the "Age" field.

 

-- Tom Fitch

 

---------------------------------------------------------

 

 

 

This is the FIND interface with many fields:

 

- FIRSTNAME

- LASTNAME

- LANGUAGE (French, English, Italian, Sapnish, Dutch, Japeneese, ...)

- AGE ( 0-10, 11-20, 21-30, 31-40, 41-50 )

 

and many others....

 

HERE IS MY PROBLEM:

 

If I want to do a research of 1 person named Christine AND who speaks

Italian or Spanish, this script have for results every personne named

Christin AND all the people who speak Italien and all the people who

speaks spanish.

 

I know that in the following script, I have 4 differents requests my

script is like this:

 

Request 1 OR Request 2 OR request 3 OR request 4

 

I want it to be like:

 

REQUEST 1 AND Request 2 AND request 3 AND request 4

 

How can I do this?

 

thanks a lot,

 

Roseline

[kitdcat]

Roseline - I am having a hard time reading through all of the previous message, however I do believe I have some helpful information. Before you write your script preform the function manually. As you take step to acheive your find write the steps down. First make sure the steps find all your criteria. Then create your script from the steps you preformed manually.

 

This always helps me.

[mike kim]

hi, rosaline ! you are bit confused about "and" & "or" search. the thing you want to do is : ( this is just simple sample)

 

set error capture [on]

go to layout

enter find mode[pause]

enter data for last name,"teresa"

enter data for first name,"gonzalez"

enter data for age,"30"

enter data for language,"spanish"

request new record

pause/resume script[]

enter data for last name,"rosa"

enter data for first name,"linda"

enter data for age,"21"

enter data for language,"italian"

perform find[]

then if( )...whatever you want.... or just whatever...

 

get back if you have further trouble.