filemaker script "Add New Request"

Posted on 2007-07-27
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

    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
    thank you lesouef:)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    If you get a (Blue Screen of Death), your system writes a small file called a minidump. Your first step is to make certain your computer is setup to record memory dumps. Right click My Computer, choose properties. Click on the advanced tab, an…
    It is a general practice to get rid of old user profiles on a computer  in a LAN environment. As I have been working with a company in a LAN environment where users move from one place to some other place at times. This will make many user profil…
    Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
    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.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now