How to script a combined search: scripted and user entered

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos Pereira - 27 Dec 2003 17:36 GMT

Hi,

FMP 5.5, FM Server 5.5, Windows 2000/XP

I need to create a script that:

- Automatically find records matching criteria1
- Enters find mode and let the user select a second criteria

The result should be a set of records that match both the first and
the second criteria. Nevertheless, I only get records matching the
second criteria, but the recors matching the first criteria are not
omited.

All the searches are within the same file, but I am using SecureFM and
I do not let the users carry out standar FileMaker searches (table
like). I have created a dialog box for entering the second criteria.

How can you script this?

What I have is:

Enter find mode (criteria1)
Perform find (Replace found set)
Go to layout1 (dialog box)
Enter find mode (Pause, then the user enter criteria2)
Perform find

I have also tried with FileMaker 6.0

Perform find (Constrain found set) in the last line of the script, but
it does not seem to make any difference.

Is there any way to script this type of search?

Thank you,

Carlos

Reply to this Message

David Herman - 27 Dec 2003 22:48 GMT

Hi Carlos,

You should enter find mode, set the criteria you want in your script and
then select 'New Record/Request' and then pause for user input. When in
Find mode, 'New Record/Request' inserts a new request to the find. This is
the way you do an 'Or' search. The way you have it now, you are performing
your first find with criteria set in the script. If you were to pause after
that script you would see that you have the records you had wanted. However,
when you enter find mode again so the user can enter their criteria, you
lose the set of records that were found with the criteria set in the script.
That is, if you're using FileMaker 5.5 to perform the find. You can not
perform a find within a found set in FileMaker 5.5 or below.

Dave Herman

> Hi,
>
[quoted text clipped - 34 lines]
>
> Carlos

Reply to this Message

Carlos Pereira - 28 Dec 2003 20:34 GMT

Thank you Dave.

Now my script looks like this:

Enter find mode (set criteria1)
Perform find (Replace found set)
Enter find mode
New record request
Pause/Resume script (resume by user input using a button)
Perform find (Constrain found set)

and it works just like I wanted!

Thanks again

Carlos

>Hi Carlos,
>
[quoted text clipped - 49 lines]
>>
>> Carlos

Reply to this Message