Hello everyone, I have been puzzling over this one for several weeks now, and haven't come up with a combination of script events that will make this work. What I am trying to do is find records in a database based on 2 possible entries into the same text field and a pushbutton toggled on.(out of many pushbuttons).

I have no trouble at all setting up a multiple find on the same text field using new record/request, but as soon as I try to do the 3rd step of the find on the pushbutton, results become unpredictable. Either I will get results with records that did not have the pushbutton toggled, or I will get results with records that do not match the 2 possible entries in the same text field.

If I just do a find on the pushbutton, my resulting found set is exactly as it should be.

If I just do the find on the text field, again, my results are as they should be.

I have tried placing the pushbutton find as the first find step, and as the last find step. I have tried setting it up as a called sub-script. Any ideas as to why this behavior?

What exactly do you mean by "push button" find. Do you mean a script triggered by a button on a layout or a find based upon a field formatted as a checkbox or radio button? -bd

I mean a field formatted as a radio button.

I can script a find on the radio buttons value. Works every time.

I can script a find on a text field, even with several "new find/requests", and it works every time.

I can script a find on the radio button, and a single find request on a text field and it works every time.

But as soon as I add the second find on the text field I start getting inconsistant and erroneous find results.

???

Hi Applal,

do you can be more specific ?

(Maybe writing metastatements of your concern)

Regards

Possible search criteria:

1. (Text field = "value 1" OR Text field = "Value 2" OR RadioButton field = "Value 3"

For this you need 3 find requests.

Request 1: Text field = "Value 1"

Request 2: Text field = "Value 2"

Request 3: RadioButton field = "Value 3"

2. (Text field = "Value 1" OR Text field = "Value 2") AND RadioButton field = "Value 3"

For this you need 2 find requests.

Request 1: Text field = "Value 1" and RadioButton field = "Value 3"

Request 2: Text field = "Value 2" and RadioButton field = "Value 3"

I suspect you were doing the first when you really wanted the second.

Thanks Bob,for the information, I was trying to do your second example, but setting it up like your first example. I had a little trouble with your example using an "and", but I found that I just had to place two "set field"s within one request. It worked, and I definitely learned something! Thank you very much!

Applal,

Could you possibly share your script for the multiple find that you said you had no problem with? I am trying to do a multiple find and keep getting just the records from the first find. I'm sure I'm missing a step or have them in the wrong order. This is what I'm doing:

Go to field "month"

Enter FIND mode (pause)

New record/request

Enter FIND mode (pause) --I have tried it with and w/o this step--since I was already in FIND mode, I wasn't sure I needed it again.

PERFORM FIND

When it pauses during the Enter Find Mode step, I click on the pop-up menu to select the month I want. I am trying to select 2 different months of my choosing, but I keep getting records back from just the first find request.

I know I am just supposed to be replying to your request, but I'm desperate. Any help would be GREATLY appreciated.

Hi Stephie,

Try this. It worked for me in a quick trial on one of my databases.

Enter Find Mode[pause] (Note, no restore)

New Record Request

Pause/Resume Script[]

Perform Find [] (Note, no restore)

The pause resume request gives you a chance to enter your second choice. I don't see any benefit to "going" to a specific field, as in paused find, any data can be entered into any field. If, on the other hand, you wish to isolate finds to just the month field, create a layout called month, and use only that field in it. Then at the beginning of your find request, tell FM to

Go To Layout [month]

and after "perform find" use

Go to Layout [whatever it's called]

Hope this helps!

Oops, sorry for the dupe!

[ June 12, 2001: Message edited by: Applal ]