filemaker script "Add New Request"

Posted on 2007-07-27
Medium Priority
Last Modified: 2011-04-14
do you know how to search record with multiple condition?
let's say i have a field have 1, 2, 3, 4 value.
i only want to search the record has 1 and 4.
do you know how to write a script?
Question by:Hiroyuki Tamura
LVL 28

Accepted Solution

lesouef earned 500 total points
ID: 19588453
2 ways:
you search fields for =1, and extend the found set woth fields =4:
Perform Find [ Specified Find Requests: Find Records; Criteria: invoice_period::invoice_period: =1 ] [ Restore ]
Extend Found Set [ Specified Find Requests: Find Records; Criteria: invoice_period::invoice_period: =4 ] [ Restore ]
you enter find mode, enter first search criterium, new field, enter 2nd criterium, then find:
Enter Find Mode [ ]
Set Field [ invoice_period::invoice_period; "=1" ]
New Record/Request
Set Field [ invoice_period::invoice_period; "=4" ]
Perform Find [ ]


Author Comment

by:Hiroyuki Tamura
ID: 19589139
thank you lesouef:)

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
Measuring Server's processing rate with a simple powershell command. The differences in processing rate also was recorded in different use-cases, when a server in free and busy states.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses
Course of the Month16 days, 15 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question