filemaker script "Add New Request"

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?
Hiroyuki TamuraField EngineerAsked:
Who is Participating?
 
lesouefConnect With a Mentor Commented:
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 ]
or
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 [ ]

0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you lesouef:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.